Good morning Smartsheet community!
We have a sheet (Sheet A) that is pulling in ship date and tracking info from another sheet (Sheet B).
On Sheet A, we have a column "Tracking Populated" as a check box with a formula that is set up to check this column if Tracking info column is not blank.
On Sheet A, we have also set up an Automation to run based on the "Tracking Populated" column being checked. The Automation will send a tracking notice to contacts listed in a contact cell, and then record the date the notification was sent in "Tracking Sent" date column .
Everything is working as planned except the automation recording the date in the "Tracking Sent" date column. The columns is set up as a date column, we have tripled checked all of the sheet and automation permissions, and those are all good, but we still cannot figure out why the automation is not recording a date.
Thank you in advance for your assistance.
