Expressions in Datashuttle have mixed results

Paula Cosentino
Paula Cosentino ✭✭✭✭✭
edited 04/17/24 in Add Ons and Integrations

We have a workflow in Datashuttle with the following under Expressions.

Submission Type - =IF(CONTAINS("A", Comments@row), "Tivity Add", IF(CONTAINS("T", Comments@row), "Tivity Term", IF(CONTAINS("C", Comments@row), "Tivity Change")))

The idea is that if a line comes in and it's an Add, Term or Change, smartsheet will designate that line appropriately under "submission Type" for reporting.

For several months, this was working perfectly, then all of a sudden the all "C" changes were being classified as "adds" instead.

This last time, some were right and some were wrong so I'm doubly confused.

The expression is looking at 1 column called "Comments." staff puts in more text than just a A, T or C. I stripped out all the text except C and this is still happening.

Is the solution to only have an A, C or T in that column? We can do that but I still wonder why it worked for so long, then didn't.

Thank you