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?
Hi all, I am trying to build out a formula that will return "True" if the CIF #@row can be found above it in the same column (CIF #) AND the Days Since Created is between 30 - 365 days. All of the formulas I have tried have only gotten me so far as the "AND". Adding in the dates screws it up. The goal is to determine if…
I am getting a lot of REF errors for my predecessors and I can't figure out why. At first I thought I might have REF for predecessors to predecessors but that's not the case. When I export the file into Excel it shows the IDs in the place where it shows REF in SS. Each time I refresh the file I feel like different values…
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
