Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier. How do I do this?
Hi,
Can you explain in more detail or maybe share the sheet or some screenshots?
That would be very helpful and make it much easier to help you in finding a solution.
Best,
Andrée Starå - Workflow Consultant @ Get Done
Starting on step 5, I have 90 days to complete the project as seen on the Goal completion date. As I enter dates starting from Step 5, I want the Expected Date to change as I enter them in the Date Column. So if I take less time to complete a task, my expected date will move up appropriately but if I take more time, my expected date will be pushed.
Hi again,
I would set the sheet up with dependencies, start and end dates. With dependencies, the completion date would update throughout the sheet when you move the date of any task.
Would that work for you?
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
