If Formula help
Hello,
I am trying to write an IF formula for my smartsheet that adds the letter A, B, C or D or E to a column pending on a dollar amount listed in another column, but I cannot seem to get the ranges to work right and everything is listed as either A or B.
Current base formula: =IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row <= 1000000, "B", IF([Total Assets]@row <= 750000, "C", IF([Total Assets]@row <= 500000, "D", "E"))))
We want the formula to add an "A" if the value is equal to or over $1000000, a "B" if it is less than $1000000, a "B" if it is equal to or over $750000, a "C" if it is between $500000 and less than $750000, a "D" if it is between $250000 and $500000 and an "E" if it is less than $250000.
I cannot seem to get this formula to work correctly for me. Can anyone help me get this functioning the way I desire written above?
Thank you!
Best Answer
-
Try this:
=IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row >= 750000, "B", IF([Total Assets]@row >= 500000, "C", IF([Total Assets]@row >= 250000, "D", "E"))))
Hope this helps!
Answers
-
Try this:
=IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row >= 750000, "B", IF([Total Assets]@row >= 500000, "C", IF([Total Assets]@row >= 250000, "D", "E"))))
Hope this helps!
-
Thank you so much!!!!
-
@TWM Happy to help! 😊
-
Hi @Kelly P.
I just wanted to put this out there too. I copy and pasted your question into the AI create a formula feature just to see what it would do. The formula came out slightly different but with the same end result.
@Alison Clancy #aiusecase
-
@Matt Johnson That's interesting; thank you for sharing! With a column name of "Total Assets", I assumed it to hold numbers, but adding the value function is a good safeguard.
-
This content has been removed.
-
This content has been removed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!