Formula for STATUS column


I'm hoping someone can help me with a formula for my 'STATUS' column on my smartsheet.

  • First off - I’d like to have all new items received in this sheet default to the status ‘Pending Approval’ in the STATUS column.
  • After they are routed and they receive approval from all 4 managers (Level 1, Level 2, Level 3 , Level 4) the status column should change to ‘Approved/Pending Scheduling’
  • If any of the Level 1-Level 4 managers decline the request the status would change to ‘Declined’
  • After all 4 levels have approved, the item will be routed to a scheduler (I will set that up through the automated workflow).
  • Once the column ‘Scheduling Complete/Added to Schedule?’ is changed to ‘Scheduled’ – I’d like that STATUS column to update to ‘Scheduled’

Thank you in advance for any help you can offer!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!