Replace IF text with numbers automatically
I have a survey coming in to a tracker. I would like to automatically replace the text answers to numerical values in my tracker.
I'd like the cell to look at its text content and replace it with specific numbers:
So if for the "communication accuracy" someone has answered "D'accord/ agree" , smartsheet looks into that cell and says ok, I need to replace this with 4.
If it is "Ni en accord ni en..." then it should replace it with 3.
Is it possible?