Formula Help

Danielle Bastos

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"))

Paul Newcome

Try something like this...

=IF(CONTAINS("Approved", [CSG Approval]@row), "Yes", "No")

Paul Newcome

Try something like this...

=IF(CONTAINS("Approved", [CSG Approval]@row), "Yes", "No")

Danielle Bastos

@Paul Newcome Thank you!

Paul Newcome

Happy to help. 👍️