Multiple IFs around Dates

Michelle Choate 2

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?

SoS | Dan Palenchar

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!

SoS | Dan Palenchar

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!

Michelle Choate 2

Perfect! Thank you!