Multiple IFs around Dates
I am trying to create a column formula that says if [Date of Record]@row is less than a specific date (7/14/23) for instance, then return the number 43. If it is between 7/14/23 and 8/22/23 then 46, and so on. Is this possible?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Best Answer
-
Hello @Michelle Choate 2 !
Yes, use this formula:
=IF([Date of Record]@row < DATE(2023, 7, 14), 43, IF([Date of Record]@row <= DATE(2023, 8, 22), 46))
It looks like this:
You can keep adding IF() statements to this for additional date limits and outputs.
Hope that helps!
___________________________________________________________________________________________
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).
🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response attention use @Dan Palenchar so I get notified of your reply!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
Hello @Michelle Choate 2 !
Yes, use this formula:
=IF([Date of Record]@row < DATE(2023, 7, 14), 43, IF([Date of Record]@row <= DATE(2023, 8, 22), 46))
It looks like this:
You can keep adding IF() statements to this for additional date limits and outputs.
Hope that helps!
___________________________________________________________________________________________
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this response helped you please help me & the community by accepting it and reacting as you see fit (💡insightful, ⬆️ Vote Up, and/or ❤️Awesome).
🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response attention use @Dan Palenchar so I get notified of your reply!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Perfect! Thank you!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
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!