My table has primary “Date” field and a “Next Date” field that uses WORKDAY({Date},3).
When a record enters the “Done” view, the automation is set up to create a new record using the “Next Date” as the “Date” for the new record.
It runs fine, but the “Date” field for the newly created record is blank.
Not sure what I’m doing wrong.
Hello @D_Austin and welcome to the Community!
This is a tricky one— from the description you’ve provided it sounds like everything should work. When you look at your Run History for the automation does it show that the date was input?
If your run history isn’t showing anything suspicious I think contacting customer support here might be the best way to go.
You can send them a short video of your automation run, and they’l be able to help figure out the problem. Also, I recommend checking out our automation troubleshooting guide if you’d like a little more context on how we generally troubleshoot automations.
Thanks. In the Run History, the Created a Record section doesn’t show that that date was input. Weird.
Thanks for your help.
EDIT: Now it seems to be working. Go figure.
Huh that’s so weird—well I’m glad it works! 
