-
Can I add something to color code for blank cells?
Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) This formula works well for what I need except that I use a template project sheet…
-
When saving as a Template do the shared filters carry into a new sheet created from the template?
I have tried this several times but the filters I create before saving as a template do not appear in the derived sheet. The check box above leads me to believe the filters should be in the template.
-
I don't want grid lines to display on my dashboard. Can these be removed (or made not to show)?
Using the Employee Contact List - Template Set, I have created an employee contact list, with reports broken out by teams. When I add the reports to my dashboard, the grid lines show. Is it possible to remove the lines so that just the text shows? Thank you! Pam
-
Getting Started Tutorial for Customers
We have built out a 'project portal' of sorts made of up several sheets, reports, and dashboards. I'm looking for anyone who has done the same and/or built a 'getting started guide' for customers to understand how the project will be managed utilizing all these components (information, status, collaborations, etc.). Anyone…
-
How to Edit an existing Template
Is there a way to Edit and Save an existing Template? It appears the only way is to create a sheet from the Template, edit the sheet, save it, and then Save As a template. It's cool if that is what is required, but wondering if I'm missing a more direct way
-
Using Project Management Templates
I'm using the PM templates and the templates utilize a section in the project plan that is called Project Information. It's handy b/c you can use this non-task related information in dashboards. What my issue is w/in the Finance section under Project Info - there is budgets and actuals. I am trying to utilize the children…
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Creating forms
I would like to know if it's possible to create a form template associated with a Smartsheet. The purpose of this form would be to collect requirements for a request that a client enters into a Smartsheet. The client would access template, complete the fields, save it, and then attach it to a specific line item in the…
-
Product Development Testing Template Set
I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tracking & Submission and Bug Report). I've reviewed it "Create New -> Browse Templates" but…
-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?