Good morning all...
I'm trying to create a formula to automatically have today's date populate a field when a different field named "Status" is changed to "Closed" or "Cancelled."
I'm not having any luck because I get errors for "Incorrect data type, number expected."
Can anyone offer a formula that would work?
So in the "Status" field, from picklist, the user selects either "Closed" or "Cancelled." A "Date Closed" field should be populated with the date that the status was moved to "Closed" or "Cancelled."
Thanks in advance for your help!