Templates
Discussion List
-
I need help so that I can calculate a percentage of completionIn Formulas and FunctionsGuys, 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 Pa…Answered - Pending Review 1 view 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Template set with URL Links not workingIn Using SmartsheetI have a project plan with 3 supporting worksheets. I want to launch the supporting worksheet FORM within my project plan. So, I copied the supporting sheets FORM URL into the attachment cell on the appropriate row for each corresponding…Answered - Pending Review 62 views 10 comments 0 points Most recent by Soccerrick10 Using Smartsheet
-
Annual Calendar Template by Day multi activitiesIn Using SmartsheetHi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?Answered - Pending Review 31 views 4 comments 1 point Most recent by Camille Cowans Using Smartsheet
-
Schedule Health formula not working,In Formulas and FunctionsHi, 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…Answered - Pending Review 12 views 3 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…
-
link hourly rates to project scheduleIn Using SmartsheetI 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?
-
Template Import Data?In Using SmartsheetI have a template with only column headings and one column with two conditional formatting rules. However, when I import a spreadsheet into the template it overwrites the template settings. Is it possible to import only data into a Smarts…
-
Any templates or sample of multiple project dashboards?In Using SmartsheetOur small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…
-
Error on copying a formula from one row to the next rowIn Formulas and FunctionsI 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 c…
-
Best practices / templates to create an NPS Form and DashboardIn Using SmartsheetGood 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/sug…
