Range of a number between three options - is this possible.
Hi All,
I need to track project by number of working days within 30, 60, or 90. I am trying to write a formula to look at (1) number and determine if this is within 30 days, between 31-60 days or anything 61+.
I am hitting a wall on trying to determine the best route to calculate this information. Any thoughts and or suggestions?
I have tried a few =IF(AND statements and keep receiving and error.
Best Answer
-
I think you're looking for a nested IF statement. Something like:
=IF(Number@row < 30, "30 days", IF(Number@row < 61, "30-60 days, "90 days"))
Answers
-
I think you're looking for a nested IF statement. Something like:
=IF(Number@row < 30, "30 days", IF(Number@row < 61, "30-60 days, "90 days"))
-
David! You are amazing! This worked thanks for helping me out. :) I hope you have a great day.
-
No problem. You do the same.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!