Formula using a checkbox column to get Yes/No
I'm trying to write a formula that will give me a yes or no in a new column when criteria is meet. For example, if in Services Needed column contains HVAC, Lock/Unlock, Lighting Only AND HVAC Completed, Lock/Unlock Completed, Lighting Only Completed are all checked then it will equal Yes in all services done? column. So far all my formula attempts have been #UNPARSEABLE
=IF(AND(CONTAINS(“Lock/Unlock”, [Services Needed]@row), CONTAINS ("HVAC", [Services Needed]@row), CONTAINS ("Lighting Only", [Services Needed]@row), [HVAC Completed]@row = 1, [Lighting Completed]@row = 1, [Lock/Unlock Complete]@row = 1), "Yes", "No")
Help Article Resources
Check out the Formula Handbook template!