Title: Cell reference value not formula
Last modified: November 29, 2017

---

# Cell reference value not formula

 *  Resolved [oapb](https://wordpress.org/support/users/oapb/)
 * (@oapb)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/cell-reference-value-not-formula/)
 * I am trying to reference a cell from a second table. The second table’s cell 
   currently has a formula, and I need that value (not the formula) to display in
   the 1st table. I am applying the Single Cell Shortcode extension, but I am missing
   something here.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcell-reference-value-not-formula%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/cell-reference-value-not-formula/#post-9732756)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * Unfortunately, it’s not possible to get the evaluated value with this method 
   🙁
    The Single Cell Extension can only retrieve the raw data (which is the formula).
 * Regards,
    Tobias
 *  Thread Starter [oapb](https://wordpress.org/support/users/oapb/)
 * (@oapb)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/cell-reference-value-not-formula/#post-9733297)
 * Is there any other option?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/cell-reference-value-not-formula/#post-9733426)
 * Hi,
 * for retrieving the calculated value, no, I don’t know another way 🙁 I’m really
   sorry.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Cell reference value not formula’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/cell-reference-value-not-formula/#post-9733426)
 * Status: resolved