# 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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!