Title: Quick Formula Question
Last modified: April 25, 2017

---

# Quick Formula Question

 *  Resolved [kentonfox](https://wordpress.org/support/users/kentonfox/)
 * (@kentonfox)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/)
 * 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](https://wordpress.org/support/users/kentonfox/)
 * (@kentonfox)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064363)
 * Just a thought. Are hidden rows and columns anything to do with this?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064371)
 * 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](https://wordpress.org/support/users/kentonfox/)
 * (@kentonfox)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064395)
 * 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](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064402)
 * 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](https://wordpress.org/support/users/kentonfox/)
 * (@kentonfox)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064587)
 * 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](https://wordpress.org/support/users/kentonfox/)
 * (@kentonfox)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9064844)
 * 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](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9065026)
 * 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.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/quick-formula-question/#post-9065026)
 * Status: resolved