Automated Workflow - Invalid Date Error

alcapps · 09/11/19

I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a date but i've trying using a date-type field and get the same error.

Andrée Starå · 09/11/19

Hi,

I think that you have to remove your post because you're mentioning things that are under NDA.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 09/11/19

I believe the original post may have been edited to remove the NDA reference and replaced with something less specific.

Paul Newcome · 09/11/19

You may want to reach out to support. Using a field change in a specific column and adding in the date condition should work even on Modified and Created date type columns.

Andrée Starå · 09/11/19

Yes, that's correct!

alcapps · 09/11/19

Thank you. I'll do that.

Paul Newcome · 09/11/19

Sure thing! Happy to help! Hopefully they are able to get it squared away for you relatively quickly.

Smartsheet Basics

Smartsheet Basics

Automated Workflow - Invalid Date Error

Comments

Quick Links

Categories

Trending in Smartsheet Basics

Create New Folders in Sheets Directory

Automations Are Not Triggering

How to make hyperlinks clickable in reports?