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 have a vendor that is helping our company with a deployment. We have given their PM access to our sheet as Edit cannot share, but when they try to add attachments to the sheet it comes up stating they do not have access to upload to that line. Why?
I have a Vlookup to a sheet that lists all the suppliers with their email addresses. In some cases, there are 2 or more email addresses. In the lookup table, they are showing as contacts, but when they are brought into the intake sheet, they are showing up as one of the email addresses and only part of the other one. What…
We have 4 users who have the basic Smartsheet account. I am aware there were changes recently, but do not understand the terminology or how it affects us. The employees use the bare basics of Smartsheet - update status of tasks, update their timesheet, or training matrix, or HSE tasks i.e. date, complete. As an SME and the…
