Output based on multiple columns

[Anonymous]

Hello All,

Hope you are doing well.

I am trying to get something like NEW COLUMN base on ID & Status columns. The status column might have combination of values and for each combination certain value is assigned as shown above.

PLease let me know if someone can help me out here.

[Anonymous]

Hi @Anonymous ,

I think you can try to set the comparison of these status. Like distinct status in each group and then give a logic like no In Progress but having multiple status like Live and Not Statred then return In Progress.

I am confused that why ID 106 will be divided into multiple groups and what is the logic. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.