Quick Formula Question

  • Resolved kentonfox

    (@kentonfox)


    7 years, 11 months ago

    Hi Tobias

    I came across your Formulas post – looks very handy but when I try to use it I get !ERROR! Cell D9 does not exist

    In Cell D9 I enter the value 1 and this shows on the page with my table
    In Cell E9 I enter 1 and this also works
    In Cell G9 I try the formula =D9+E9

    This creates !ERROR! Cell D9 does not exist? But of course I know it does ??

    Also, it would be very useful for me to copy the contents of another cell by using the = formula. ie In Cell D9 enter =E9 to copy the value of E9 across to D9
    But I suspect this is not possible?

    Thanks for your time as always

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter kentonfox

    (@kentonfox)

    Just a thought. Are hidden rows and columns anything to do with this?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    That sounds strange…
    Hidden rows and columns should not actually play a role here, as they are only hidden after all formulas are evaluated.

    Regards,
    Tobias

    Thread Starter kentonfox

    (@kentonfox)

    To save you time, my real goal is to be able to reference a cell from another cell….

    it would be very useful for me to copy the contents of another cell by using the = formula. ie In Cell D9 enter =E9 to copy the value of E9 across to D9

    I want to do this, so I can easily add a image link to another cell (stored in E9), after an import from a form, where the imported field simply says =E9
    I thought this might get around the issues of csv imports of image URLS which don’t work.

    is this referencing an cell this way possible?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    referencing cells in this way is no problem at all, however, there’s a different problem:
    You can only use cells that are number or formulas themselves in such formulas. Thus, you can not reference cells that contain text (or HTML code).

    Regards,
    Tobias

    Thread Starter kentonfox

    (@kentonfox)

    Thanks Tobias

    FYI the issue with adding cells I think was related to using a filter in the shortcode.

    I created a new table with no filters in the shortcode and the formula works.

    Thread Starter kentonfox

    (@kentonfox)

    FYI with regards the issue of using HTML when importing CSV files from forms. I found that the HMTL gets corrupted.

    In case its helpful for others ….

    I used a plugin to create custom shortcodes for the HTML I wanted to import via CSV. This shortcode is then successfully imported into TablePress and the linked HTML then correctly delivers the image and link.

    Maybe not the most elegant solution, but it allows me to proceed.

    Best

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yes, using a filter can have influence here as well, as this can also lead to rows/columns being hidden.

    Good to hear that you found a solution for that HTML in the CSV file ??

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Quick Formula Question’ is closed to new replies.