Hi,
I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change.
For example:
If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date.
What I have currently:
=IF([Invoice Status]@row = "Awaiting MGR Approval", TODAY())
The field names:
- Invoice Status (status field)
- Date sent to Manager for Approval (date field)
- Date sent to MSC (date field)
The above wipes out one or the other date. Cannot be applied to both fields.
Thank you for your help!
