Forum Discussion
ChayceDuncan
7 months agoQrew Captain
You can just check first to see if Finish date is in the future and nullify it. You also don't have to nest each new if as a new statement to make it more readable, you can just do like so:
If(
[Finish Date]>=Today(), null,
[Status]="Overdue",Today() - [Finish Date],
Status]="Not Started",Today() - [Finish Date],
[Status]="In Process",Today() - [Finish Date],
null)
------------------------------
Chayce Duncan
------------------------------
- JackWoods7 months agoQrew Trainee
Thank you, Chayce. that worked.
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------