Hi you all, I have a table "jobs" and anothe...

[Alex_Meraru]

Hi you all,

I have a table “jobs” and another one “stops” One job can have multiple stops. Both the job and the stops table have a status column. I want the job’s status to be automated in relation to stops status.

example: All the stops have the status " Planned"

• I want the job’s status to be “Planned” When I change the first stop to active, the job’s status to be active too.

just to test the functionality, I tried it this way:

=IF(lookup(“JobNo”,Stops,JobNo,Status)=“2.Active”,“2.Active”,“Unkown”)

What am I doing wrong?

Thank you!

[Bellave_Jayaram]

Try IFS(IN(“2.Active”,[Related Stops][Status]), “2.Active”)

[Alex_Meraru]

@Bellave_Jayaram thank you! It is working but to update the “job” record I need to edit it first and save it. Is this the only way?

[Bellave_Jayaram]

The other way is to use data change workflow described here - http://help.appsheet.com/behavior/workflow-changing-data/changing-data-from-a-workflow-rule-or-sched...

[Alex_Meraru]

You’re my new hero!

[Aleksi_Alkio]

Another solution is using virtual column for this purpose.

[Alex_Meraru]

I’m not good with virtual columns yet.

Good to know, I will try to get better with it.

Thank you!!