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!