Formula is not Generating the correct value
So we have a formula in column labeled "Section 1 ended" 
=IF([Column A]@row > 20000000, "10", IF([Column A]@row < 1000000, "2.5", IF([Column A)]@row > 10000000 < 20000000, "7.5")))
and it generates correctly. However, when I try to then use the value from that formula in Column B to multiply by 8 in another formula, it keeps spitting out a value of 0 instead of the actual value, which in the screenshot should be 80.
=SUM([Section 1 Ended]1) * 8
Does anyone know what I'm doing wrong with this formula?
Tags:
Best Answer

Use VALUE function instead in Column B as below,
=VALUE([Section 1 Ended]@row)*8
Answers

Use VALUE function instead in Column B as below,
=VALUE([Section 1 Ended]@row)*8

ahh so simple, and worked perfectly, thank you!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!