I currently have a formula column that takes one of 3 status options and outputs a text result in the column depending if they choose option 1, 2 or 3. So let’s say the result is A, B and C. I’m trying to find some way to copy the result (A, B or C) from the formula column to another text column so that I can include that result into yet another automation since I can’t bring the formula column directly into the automation.
note: general caster is NOT working for this solution. It is outputting the result #name? in the new column but the formula is valid and functioning in the formula column.