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
When I publish the calendar view, not all my tasks are showing up. I have all filters off. In my regular view on the sheet, the tasks are there.
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…
Good day, I have the above simple automation to copy a row to another sheet when a specific checkbox is checked. I am having two issues: The automation does not run when the box is checked When I run the automation manually, all the rows in the first grid, are copied to the destination grid. How can I fix the automation…
