Formula Help

Hi All,

I have an approval column which which clicked on, would like to have a tick/cross at the beginning of the row.. Essentially, if CSG Approval (Column 1) is approved, a green tick (as yes in column properties) should appear in Project Approval (column 2) vice versa, if rejected, should have a red cross (as no in column properties) in project approval.

The formula I have is not working and I've tried to manipulate as much as possible. Can anyone please help :)

=IF([CSG Approval]@row = "Approved - Strategic", "Approved - Departmental", "Yes"), IF([CSG Approval]@row = "Reject", "No"))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!