Total sum of results of a formula?
I have a formula to calculate payouts as follows:
=IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "$2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row < 1000000), "$5000", IF([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 100000, "$10000")))
I would like to total this column so I can see the total payout, but it doesn't work and returns a value ZERO.
Is it possible to sum the total of the "results" of the formula above?
Best Answers
-
By putting your dollar values in quotes, you're forcing Smartsheet to create them as text values, and Smartsheet can't do math on text values. Remove the quotes and they'll be saved as dollar values, and then your sum will work.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
That worked!! Thank you!!
Answers
-
By putting your dollar values in quotes, you're forcing Smartsheet to create them as text values, and Smartsheet can't do math on text values. Remove the quotes and they'll be saved as dollar values, and then your sum will work.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman I took the dollar sign out and it still returns a "zero" value:
=IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row < 1000000), "5000", IF([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 100000, "10000")))
-
@Desmond Smith The quotes, Desmond. Take out the quotes. The dollar signs can stay.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
That worked!! Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!