1

Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App?

We have a calendar that references an existing Smartsheet - Sheet.

The sheet has a contact list column labeled

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