I am trying to get this formular to do a different formular based on values in a specific column.
=IFERROR(IF(CurrencyBuildLocation@row = "CAD", ([Revenue $ CAD]@row - [Total Costs]@row) / [Revenue $ CAD]@row), IF(CurrencyBuildLocation@row = "USD", ([Revenue $USD]@row - [Total Costs]@row) / [Revenue $USD]@row))
Best Answer
-
Try removing the IFERROR as well as the closing parenthesis after the second [Revenue $ CAD]@row.
Answers
-
Are you getting an error?
-
The only output i get is this part IF(CurrencyBuildLocation@row = "CAD", ([Revenue $ CAD]@row - [Total Costs]@row) / [Revenue $ CAD]@row).
No output from the second part.
-
Try removing the IFERROR as well as the closing parenthesis after the second [Revenue $ CAD]@row.
-
This solved my problem. Thank you
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!