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.
1 Like
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.
I have the same problem - did you ever find a solution?
If you’re open to trying a third-party app, you can check out Column to Column. It includes a recipe for copying data from a formula column to a standard column:
If you have any question or run into issues, reach out to us!