I have 5 dropdown "status" columns, and one "summary" column that needs to auto-populate. Looks like this:
I need the Condition (Automated) cell to look at the previous 5 cells, determine which is populated, then enter the name of the cell that is populated. In this case, the "2. Design" cell is populated from the drop down list, and the "Condition (Automated)" column reflects that… because I manually populated the column.
I asked Smartsheet's AI to write a formula for the Condition column to look at the 5 status columns then populate the Condition column…
This is an elegant solution! So I copied it, populating the fields. Unfortunately I can't get it to work, it gives me the dreaded #UNPARSEABLE message. Here's what my formula looks like:
Interestingly, it works if I only tell it to check the first column. When I try to add the second column I get the "#UNPARSEABLE" response.
Wondering if I missed a quote, a coma, or a parenthesis somewhere… OR if there's an easier formula for this task? (Automation does this well, but I need automation to do something else with the same cells simultaneously (and automation can ONLY do one of these two tasks at a time)… so I need a formula to read the cells.)
Thanks for reading this, and thanks in advance for any help!
