I want to track how long an open task is delayed on a project
You might be interested in using the baseline method to track planned vs actuals: https://www.smartsheet.com/blog/quick-guide-mimicking-baseline-functionality-smartsheet
By how long you mean:
How much diff there was from the initial due date?
If a task is not completed, how much time past from the due date (meaning Today - Due date)?
How long has past since a task is considered delayed (time that past since status was changed to "delayed", etc.)?
or, something else?
Sorry, I was out of the office. I would like to track: If a task is not completed, how much time has past from due date and also track due date changes (the difference between the original due date and new due date) open task only.
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.