-
COUNTIF Checkbox Marked and Then COUNT Product
There is a column called "Terminated" and it is a checkbox and 5 other columns with Product1, Product2, Product3, Product4, and Product5 which are also checkboxes. I need a formula to COUNTIF "Terminated" is Checked, then COUNT the Product1, Product2, Product3, Product4, and Product5 columns. For Example: Terminated =…
-
What is the best way to create a Pert Chart with Smartsheets?
I don't see an option for it in the "View" button for my project. I did find this article in the help pages: https://www.smartsheet.com/pert-101-charts-analysis-and-templates-more-accurate-project-time-estimates#pert-analysis-how-likely-will-the-project-be-on-time Which says "if you do it by hand" implying there's another…
-
COUNT by Manager and by Product
I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes How can I do a count by Manager of Product? Example: Joe Smith * Product1 - 3 * Product2 - 10 Jennifer Johnson * Product2 - 12 * Product3 - 5 * Product5 - 10
-
Formula counting State
I have a column called "State". How can I do a count by all "State" and produce a chart? I want to avoid doing a formula for each State. Suggestion?
-
Web Content Widget - Having to keep logging back in
Hello, I'm pulling in specific information from an online excel doc to a dashboard I created. Each day or every other day, I keep having to log back in to view the data in the dashboard. Is there a way around this? Is there a setting I need to update? Thank you, Sean
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
Gantt Chart in Dashboards
Hi, I've added a report to my dashboard and used the setting to show the gantt chart. I've set the gantt in the report to open to today's date, but on the dashboard it's not doing that. Is there a way to edit this so the gantt chart opens to today's date in the dashboard? Thanks
-
Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
-
Non-Task Related Project Description/Information/Demographics
Is there a way to add Non-Task Related Project Description/Information/Demographics to a project without using rows? I feel like we need a demographics page that we can add non task data.
-
Removing Parent Rows from a report
Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projects in a certain workspace and looks for tasks that are past their due date, then outputs the project name, task and who it…