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:
Hi, which formula can I use to calculate the expected Progress (depending on the current date)?
Thanks
Could you give more details and share some screenshots?
Hi Paul,
I have the Start Date, End Date, Duration (days) and the Progress given by each responsible. From this Information I would like to calculate the expected Progress, how shall the Project must be going on an specific date.
For example:
I have a Task with 10 days as Duration. by the second day the Progress completed is 20% (that means is running accordingly to plan) and by the third day, the Progress is the same. That means that by the third day the Project has already a delay.
So I would like to know which formula can I use to find out this expected or planned Progress and then I can be able to make a comparison against Progress completed and create alerts if neccesary.
Thanks.
If you create a [Projected % Complete] column, you can enter this formula into it...
=(TODAY() - [Start Date]@row) / ([Scheduled End Date]@row- [Start Date]@row)
This will give you how far into the scheduled time you are for whatever today's date is. You can then build your alerts off of whether your actual % complete is less than, greater than, or equal to where you should be (projected % complete).
To show the projected finish date based off of the current progress and the start date, create a date type column [Projected End Date] and insert this formula...
=[Start Date]@row+ ((((TODAY() - [Start Date]@row) / ([Scheduled End Date]@row - [Start Date]@row)) - [Actual % Complete]@row) * ([Scheduled End Date]@row - [Start Date]@row)) + ([Scheduled End Date]@row - [Start Date]@row)
Thank you!
I have a similar request: I would like to see how the projected end date of a task will impact the overall projected end date of the project taking the predecessor relationships into account. Any ideas on how to do that with a function or in a dashboard?
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
