Formula for STATUS column

Jason Templer

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!

Paul Newcome

Try something like this...

=IF([Scheduling Complete/Added to Schedule?]@row = "Scheduled", "Scheduled", IF(COUNTIFS([First Approval Column]@row:[Last Approval Column]@row) = 4, "Approved", "Approved", IF(CONTAINS("Declined", [First Approval Column]@row:[Last Approval Column]@row), "Declined", "Pending Approval")))

Paul Newcome

Try something like this...

=IF([Scheduling Complete/Added to Schedule?]@row = "Scheduled", "Scheduled", IF(COUNTIFS([First Approval Column]@row:[Last Approval Column]@row) = 4, "Approved", "Approved", IF(CONTAINS("Declined", [First Approval Column]@row:[Last Approval Column]@row), "Declined", "Pending Approval")))

Jason Templer

This worked perfectly, thank you so much Paul! You're amazing!

I just posted a new question separately - any chance you can help? :) Thanks!

Jason

Paul Newcome

Happy to help! 👍️

I'd be happy to take a look. Can you post a link to it?