Formula Help

Manuel Lemus

HI,

I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "Green".

Genevieve P.

Hi @Manuel Lemus

You can use an AND statement inside of an IF function to achieve this.

Try something like this:

=IF(AND([2022 Show Start Date]@row <= TODAY(90), [Rebook Plan in Place]@row, 0), "Red", "Green")

Here are some resources that may be helpful for you:

• Use Formulas to Perform Calculations With Dates
• TODAY Function
• IF Function
• AND Function

Let me know if this works for you!

Cheers,

Genevieve