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

[wabukhari]

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  

[lynchk21 · Accepted solution]

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" ) )

[wabukhari]

@lynchk21  Thank you very much.