-
How do I display a different symbol based on multiple values?
I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work. I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display. Scenario: 0% = Green 1% - 10% = Yellow 11% and over = Red This is the formula I'm currently using. I get the Green…
-
JIRA Sync To Smartsheets Not Syncing
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually, edit it, then let it run every day. This is NOT automatic syncing like its intended…
-
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,…
