How to change values in cell based on other cell value

Question

Hi All,

I am new so not sure how this works but just trying my luck.

Need help with the below.

Product IDSub IDStatusStatusA123  Pass 123fail  123Pass  123TBD  123medium

I want to update the 'StatusA'  column based on the 'Status"  column value, Status A is already updated but needs to be updated based on column 'Status'. In this case I want the column ' StatusA' updated as " fail ".  If there is no " fail" then Status A should pick "TBD". So the ranking is 1. Fail 2. TBD 3. Pass 4. Medium. I have multiple Product Ids where 'StatusA' should reflect SubID Status based on the ranking.

Thank you

Rishi

danilang · Accepted Answer

Hi @rshetty

Here's one way to do it

The workflow concatenates the Status values for the Sub Id rows and then calculates the new status with an if-then-else based on your ranking order.  This new status is joined with ProductID rows and unioned with SubID rows and sorted to give you

Dan