Formula assistance

murf26

New user

Looking to have formula that will have the following actions occur within a sheet.

When the below is entered within the specific column then the status would automatically populate accordingly. Status is drop down list with the options outlined in Column C

Any help greatly apprecaited

hollyconradsmith

Hi @murf26,

Try using the automations "Update Cell Value" for this!

https://help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow

However, you could use a nested "if" formula if that is you preferred route:

=IF(and([specific target date]@row=TBU, isblank([actual finalization date]@row, "Not Started", if(and([specific target date]@row>TODAY()-30, isblank([actual finalization date]@row, "In Progress-Due within 30 days", ...etc