Issue can't update a Delivery Date in a report, source sheet populating Delivery date with formula
Referencing this chat string from 2021. https://community.smartsheet.com/discussion/75430/reports-some-fields-can-be-updated
How can I maintain both a calculated delivery date in the source sheet and allow project managers to manually adjust dates in reports? I know I could add a helper column to show the original calculated date, but that doesn't solve the issue of needing both automatic calculations and manual adjustments.
Answers
-
@PDunn Keep the calculated date then have an override column. Update the calculated date formula to look at the override column and pull it in if it isn't blank.
This assumes you aren't trying to update a project column "end date" for a Gantt chart. If it's a project column, they can't be updated in a report. however, the duration column canβ¦.
Darren Mullen - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
It isn't a project column just basic column that is calculating a date based on lead time. I have added a Date Override column updated my existing formula and works perfectly thank you for the quick response.
