Need help in renaming the values of column Status .
So if the filter chosen is Asia the status remains same but when filter changes to Europe then the values for status changes from
'In review' to 'A'
'not started' to 'B'
in progress to 'C'
done to 'D'
Please find the sample data and desired output for the reference
Thanks
Hello,
You can create this calculated field:
IF [Location]='Asia' then [Status]
ELSEIF [Location]='Europe' then
IF [Status]='in review' then 'A'
ELSEIF [Status]='not started' then 'B'
ELSEIF [Status]='in progress' then 'C'
ELSEIF [Status]='done' then 'D'
END
END
See my workbook attached.
If this post resolves the question, would you please "Select as Best"? This will help other people find the same answer and help community keep track of answered questions.
Thank you.
