Can I add another condition to a formula?



I have a column that I am using a formula to return the Quarter based on a date. The date column doesn't always contain a date though. Sometimes it contains text. Can I add something to the formula to return NA if the content is "Evergreen" and return the Quarter if it's a date?

Here is the formula I am using:

=IF(MONTH([Request RenewalDate]@row)< 4, "Q1", IF(MONTH([RequestRenewal Date]@row)< 7, Q2", IF(MONTH([RequestRenewal Date]@row)< 10, "Q3", "Q4")))

Thanks ahead of time!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!