Sign in to join the conversation:
I am creating a basic task check list that restarts every 4 weeks. I would like to set a task for Day 1 and automatically set all of the future task due dates based on lag time. I am not using predecessors.
I would appreciate suggestions.
Hi,
Please see attached link/screenshot. (The - sign should be
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
If you want those dates to be based on weeks, you would want to calculate it in days. =date1+7 is for one week past due date, and for two weeks you would use =date1+14.
To speed the entry of these formulas, you can (and should) use absolute referencing, like this:
=[Target Date]$1 + 1
=[Target Date]$1 + 2
Two cells can be selected and dragged down to increment them. Since that will run into weekends too, I would add another column for the lag (Text/Number)
Then the formula becomes
=[Target Date]$1 + [Lag]@row
Craig
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
