IF () formula, Change Status Dependate on Date

Camper Reparadise

I would like to build a formula so that status will change to "Red" and type will change to "Renew"  when date is past "Expire Date".  I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency.



Can I make this into one concise formula? 

 =IF([Expire Date]@row < TODAY(), "Red") and =IF([Expire Date]@row < TODAY(), "Renew")

Attended the Smartsheets Engage '18... I know it's possible! 

Thanks, 

   Kendra

Andrée Starå

Hi Kendra,

Try this.

How would you like to combine them?

Status

=IF([Expire Date]@row < TODAY(); "Red")    

The same version but with the below changes for your and others convenience.  

=IF([Expire Date]@row < TODAY(), "Red")

Type

=IF([Expire Date]@row < TODAY(); "Renew")    

The same version but with the below changes for your and others convenience.  

=IF([Expire Date]@row < TODAY(), "Renew")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Camper Reparadise

Andree, 

 

Thanks for your response. I'd like to combine just to see the full function of the formula in one place...good practice and whatnot. What am I missing? Hasn't worked so far.

=IF([Expire Date]@row < TODAY(), "Renew", =IF([Expire Date]@row < TODAY(), "Red"))

 

It still fills column to "Renew" or "Red"-- I only want this to happen when date has passed expire date (day of would be fine too) . 

 

 

 

Andrée Starå

Happy to help!

I'm not sure if understand you correctly. The above formula checks for the same thing so it can't be in the same formula.

Best,

Andrée

Andrée Starå

Hi,

How did it go? Did you manage to get something set up?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Camper Reparadise

Andree, 

 

It worked! A silly oversight, but I wasn't applying each formula to the appropriate column that it was working from. I was trying to make both seperate actions function from one column. Thanks for your guidance! 

Andrée Starå

Great!

Happy to help!

Best,

Andrée