If Error Added to ROI Formula
Smartsheet Community:
I tried to add IFError to the Formula below to Return Blank in the Event I have 0.00 Investment (Investment $$ Column)
Original Formula:
=([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row
Thanks
Best Answer
-
Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.
=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")
Answers
-
Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.
=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")
-
I'm glad you were able to figure it out! Thanks for posting your solution. 🙂
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!