-
I need help so that I can calculate a percentage of completion
Guys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Parents Status in the Status column. Thank you and I am waiting for your advice.
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…
-
link hourly rates to project schedule
I would like to link my artist's hourly rates to tasks in a project schedule to get an estimated hard cost. How do I do this?
-
Error on copying a formula from one row to the next row
I am using the Survey Intake - Employee Pulse Check template package to create an NPS survey sheet, report and dashboard. I've updated my questions on the template sheet and I am now editing the "helper columns" to reflect the changed questions. I created a formula to count my responses on the first row, but when I try to…
-
Best practices / templates to create an NPS Form and Dashboard
Good afternoon, I need to create a form to measure Net Promoter Score (NPS) for our PMO office. I have samples for the questions, but I would like to know if anyone has experience building a form specifically to measure NPS. Any ideas/suggestions are welcome. Thanks! Silvana
-
Using templates vs sheets in "template set"
Hi, I am creating template "sets" similar to what SmartSheet has created so that our workplan has the same related reports and dashboards for every project. Because we have a lot of users, I like the idea of having the main workplan in a template so that it cannot be overwritten. However, I noticed that in none of…
-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Truck Sales Process Template
Hello, I work for a heavy duty truck sales company and we'd like to implement a system that will allow us to track what trucks we've ordered, what their current status is, what trucks have been purchased by customers and ideally send out documents that customers need to sign and return to us; all through an automated…
-
When downloading a template set, the dashboard doesn't seem to download with it.
I have been trying to download the Project Tracking and Rollup as well as the Project Schedule Management templates, which are both supposed to include pre-made dashboards, but the dashboards do not seem to download or populate. When I move the template set to a workspace, the dashboards still do not show, and when I…
