I am trying to set up a project management portal. I have two tables, projects and tasks. When I update the status of a project, I want to create a task in the tasks table, and set the due date of the task ahead one week from today.
All is well until I get to entering the value for the due date field. I can’t seem to get it to resolve functions. As a test, tried to use TODAY() in the textbox of my field in the automation, but when I trigger it, the “runs” section claims it errors out with:
Field “Due” cannot accept the provided value: Could not convert string to date.
So it is trying to convert the string “TODAY()” to a date. I’ve tried {TODAY()} and =TODAY() with no success. Am I missing something or is this impossible?
The only thing I can think of as a dirty workaround is to create a new formula field in the projects table that does something like DATEADD(TODAY(), 7, “days”), then reference this field when setting the value of “due” in my automation. This actually DOES work, but man that seems messy.