I mistakenly changed a column from text to date. Saw the error and changed it back. But when I made the change from text to date it broke formula, and changing the column back to text didn’t fix the problem.
When I try to fix or recreate the formula the column, the column always appears in the formula workspace as a date not text (see screenshots) so I cannot get the formula to work.
FWIW, I think I have had this happen before…but I can’t remember what I did to fix it.
Can anyone tell me how to get the column type corrected in the formula workspace?
Many thanks, Gregg