Lookup values on one table and update value in another if contition is true

AppSheet AppSheet Q&A
, ,
6

Thank you. I had also requested to post [Status] column setting. Assuming it has default status of “In Progress” and the only other status possible being “Completed”, please try following

1. Action: Update Driver Onboarding Status to Completed

Set these columns Status
Use expression : IF(IN(“In Progress”, [Related Tasks][Status]), “In Progress”, “Completed”)

2. Action: Update Driver Onboarding Status to Completed 2
Referenced Rows
LIST([Ref Column Name that refers the Driver Onboarding Table in Onboarding Tasks Table])

3. Workflow
Condition
AND( [_THISROW_BEFORE].[Status]<> [_THISROW_AFTER].[Status], [_THISROW_AFTER].[Status]=“Completed”)