# Invalid data type
I have a column "OSP SLA ATTESTATION" there are 3 dropdown choices "All SLAs have been met and there were no breaches", "SLA not met &/or breach", "Service not used for period"
When the cell is populated with one of these drop downs I want to formula to result in "submitted"
Formula below:
=IF(OR([OSP SLA Attestation]@row = "All SLAs have been met and there were no breaches", "SLA not met a&/or breach", "Service not used for period"), "submitted")
I have played around with the formula but no joy. Any suggestions?
Best Answer
-
Ensure your column is of type text. Also I believe the OR function requires declaration of the column@row for each instance.
Try something like this:
=IF(OR([OSP SLA Attestation]@row = "All SLAs have been met and there were no breaches", [OSP SLA Attestation]@row = "SLA not met &/or breach", [OSP SLA Attestation]@row = "Service not used for period"), "submitted")
Hope this helps!
Answers
-
Ensure your column is of type text. Also I believe the OR function requires declaration of the column@row for each instance.
Try something like this:
=IF(OR([OSP SLA Attestation]@row = "All SLAs have been met and there were no breaches", [OSP SLA Attestation]@row = "SLA not met &/or breach", [OSP SLA Attestation]@row = "Service not used for period"), "submitted")
Hope this helps!
-
Thanks Christian... worked a treat :)
Help Article Resources
Categories
Check out the Formula Handbook template!