Using Action to change a col value on the basis of another col value

AppSheet AppSheet Q&A
1

I have tried to set the value of a col Job status through an action using the following code:
If( [Visit Schedule Date] < Today(), [Job Status] = “Overdue”, If( OR( [Visit Schedule Date] = Today(), AND( [Visit Schedule Date] > Today(), [Visit Schedule Date] < Today() + 15 ) ), [Job Status] = “Due”, [Job Status] = “Pending” ) ). it writes the value “FALSE” in Job status colmn , while the visit schedule date has the value 06/05/2024

2

If( [Visit Schedule Date] < Today(), “Overdue”, If( OR( [Visit Schedule Date] = Today(), AND( [Visit Schedule Date] > Today(), [Visit Schedule Date] < Today() + 15 ) ), “Due”, “Pending” ) )

You need to alter the expression to remove the [Job Status]= column in the condition (see above)

If( [Visit Schedule Date] < Today(), [Job Status] = “Overdue”, If( OR( [Visit Schedule Date] = Today(), AND( [Visit Schedule Date] > Today(), [Visit Schedule Date] < Today() + 15 ) ), [Job Status] = “Due”, [Job Status] = “Pending” ) )

1 Like
3

@lynchk21 Thank you very much.

1 Like