IF OR Statements not working correctly
I have a question on 'IF' 'OR' statements. I researched and created one that looks like it should work. I am trying to display a status field with 'Completed' or 'Cancelled' and I have the field to start with an auto-fill - from the form with 'In-Progress'. I tried making each statement in its own field to display separately, but that wasn't working and it was a mess. Then I found with 'OR' I could combine them all, and I get argument statement not found or data not recognized. Can someone help me with this? I was placing the below in a separate "function" column to hold this since I have the Status column auto-populating with 'In-Progress' from the form when submitted.
=IF([Item Ordered]@row= "1", Status@row, "Completed", IF(OR([Supervisor Review]@row = "Decline", [IT Approval]@row= "Declined", [Funds Certifier Approval]@row= "Declined", [Approving Official Approval]@row= "Declined", Status@row, "Canceled"))
Help Article Resources
Check out the Formula Handbook template!