Timestamp Workflow not working

Bill Raymond

I found someone's article (link) about how to timestamp using a workflow. I tried it exactly the way the article set it up and rather than timestamping newly entered lines, it completely overwrote every single date in the column including all previously entered lines.

I also tried all of these (using the trigger "when rows are added") and nothing is entering to new lines at all.

I just need a simple solution that puts todays date in to a column automatically.

• I created the sheet and am the Admin (confirmed)
• It would be less work to manually enter the date than to set up a helper sheet
• Nobody else has access to the sheet
• There are no other automations on this sheet
• Nothing is feeding, or reading the cells being referenced above
• This sheet exists in isolation solely to keep track of my tasks and subtasks, the date they started, and what priority level they are

How do I get Smartsheet to automatically fill in today's date for all new lines entered to the sheet?

markkrebs

Because the gantt doesn't allow a formula column to be the start or end date.

markkrebs

Bill Raymond

Never mind. I found the column option for timestamp.

NOW my problem is getting it in to Gantt view as it apparently doesn't like any of my columns. I have a column that automatically records the date, a column for the deadline (calculated), and I even made a 3rd column to convert the date from the Created column to see if that would fix anything. It keeps giving me the same error message.

Why do I have to have 2 manual date columns in order to use Gantt view?

markkrebs

Because the gantt doesn't allow a formula column to be the start or end date.

markkrebs

There are some workarounds to trick the system but thats how OOB works