Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

# 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

  • Community Champion
    Answer ✓

    Hi @Kieran Howard

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions