Hello,
I would need a formula for IF a field in the column appears 2+ times THEN change the last character of a string in that field.
Ie,
Name
Tony
Mark
Isabel
Would change to
Tony_1
Thank you!
Hey @insomned,
Herse a simple setup to achieve that:
The multi row groups by name and counts the number of instances. The Formula then adds on the number if its greater then 1.
Hope that makes sense,
Ira
@insomned I like to use the Tile tool for the grouping and sequencing situation like this case.
@insomned another way of doing this with
Hello @insomned, try this workflow it is dynamic. I have tried a few cases and it works.
