Populate a text value based on a date range

Cheryl Lock
Cheryl Lock ✭✭✭
edited 07/06/20 in Formulas and Functions

Hi All,

I'm fairly new to Smartsheet and I'm trying to set a text value based on a date range. Reading through all the responses it seems possible but a little messy. All I'm trying to do is automatically populate a Quarter value based on custom ranges. No cross sheet references, all in the same sheet. When I only use two statements, it's working fine:


=IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 1, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 3, 31)), "Winter", IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 4, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 6, 30)), "Spring", "Test"))


When I use the needed 4 statements, I get #UNPARSEABLE


=IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 1, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 3, 31)), "Winter", IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 4, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 6, 30)), “Spring", IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 7, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 8, 31)), “Summer”, IF(AND([SYSTEM: TLH Request Form Timestamp]@row >= DATE(2020, 9, 1), [SYSTEM: TLH Request Form Timestamp]@row <= DATE(2020, 12, 31)), “Autumn”, “Broken”))


I'm perplexed, does anyone see anything I'm doing wrong?

Best,

Cheryl

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!