-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
Lookup() returning #NO MATCH when it is definitely there
I have created a new sheet to store the priority values of my ticketing system so if I change the values I don't need to change all the formulas on my main sheet. It's used to determine when to set the due date. It works fine for Low and normal, when I change the values it changes the due date correctly, but when I select…
-
Is it possible to select multiple sheets and share at the same time?
We have roughly 35 sheets that need to be shared with a group of people. Is there a way to do this in one transaction rather than sharing each sheet separately? Thanks!
-
No Title for Second Column Selected in Chart on Dashboard
Hi Everyone, Thanks for your help. I've got a few spreadsheets with data collected, and I'm trying to make a chart on a dashboard. I'm very comfortable in Excel, but for some reason I can't get the title for the second column to read in my charts. I have flipped back and forth between "Switch Rows/Columns" and that doesn't…
-
Prevent Overwriting of "Handler" Column
Hello, We have a smartsheet for our support team to claim requests submitted. As of now, when a form is submitted- every member of the support team receives an alert. From there, one of them must enter the sheet and elect themselves to handle the request (dropdown field with their names). We've run in to an issue where…
-
Placeholder for Start/End Dates
I've discovered that the % Complete column will only take into account rows with populated Task Start/End Dates - but this gives a distorted view of how much of the project is complete in the Parent Row. Is there a placeholder date or workaround I can use without making my own % Complete column using formulas?
-
Rows Not Appearing
I'm trying to troubleshoot a sheet I have. I have several entries that are not appearing on my sheet, and any new entries made are also not visible. I have a report generated off of the sheet and it reflects all of the entries. The approval, update, and assignment automation is also working just fine. They are given a row…
-
Metrics: Using the metrics template and metadata
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metadata report and a metrics report Problem: I have to manually link the portfolio,…
-
Filter only children row when certain criteria is met.
Hello Community, What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked. Once I am able to filter the rows that…
-
Changing more than one sheet
Hi, I was wondering if there was a way to alter sheets based on a single template without having to go into each one individually? If I had a template that I used for different task lists and I wanted to add a column, automation, or even a choice in a dropdown, is there a way for me to do that simultaneously throughout all…
