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
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
I need to delete my Smartsheet account but I don't know how to di it. Does anyone know how I can reach a real human being to ask?
