1

Hello Smartsheet Community, I work for the City of Minneapolis, in Minnesota, and I’m looking to reach out to see who is working for governments (local, county, state, or federal) while incorporating Smartsheet into their utility project management processes. Smartsheet is restricted from its

3

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