Just a minor change to your automation. Instead of it being “triggered” every day, use the automation trigger “When date arrives”. This allows you to choose the same date as the milestone date and even before or after the date.
Hi
Sincerely thanks for the input. The suggested formula ONLY works for the “new added item”. Any old item with old project start date will not apply to the expected following workflow
New Addup Item (Workflow PASS)
Stage 1:
New Column Create as “Project Start Date”
Stage 2:
When an item is created, set “Project Start Date” to today.
Stage 3:
10 days “Project Start Date” arrives and only if “Development Status” is “Concept”, set “Development Status” to “Pending”
Issue:
Old item with “old project start date” will not change its status automatically.