# Multiple IFs around Dates

Options
✭✭✭✭✭

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?

Tags:

• ✭✭✭✭✭✭
Options

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

PS - If you have a follow up response attention use @Dan Palenchar so I get notified of your reply!

👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

• ✭✭✭✭✭✭
Options

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

PS - If you have a follow up response attention use @Dan Palenchar so I get notified of your reply!

👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

• ✭✭✭✭✭
Options

Perfect! Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!