Best Of
Health Status Formula
Hi!
Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green.
Sorry .. very new to this.
lukas.johnson
Re: Dynamic Filter on Dashboards
@Francisco This thread isn't monitored by the product team either. I'm pretty sure we're all sent here to air our ideas and to make us feel like we're contributing, but in reality they just fade away.
XR_Tech404
Re: Dashboards: Only one of 100+ dashboards has zoom options?
Thanks @Barak Schriger! That solves the mystery and why we haven't been able to revert it. Great tip about the "Zoom to Fit" option.
jmhoward
Countifs/Sumifs with multiple criteria which reference another sheet
I'm trying to make a Metrics sheet to use on a dashboard. I would like to count all of the instances of each (text) heading which fall during this month, then a second column for last month.
I can't get the dates to work so I created helper columns with the month, year, and month+year combined (ex April 2025 would be 42025).
Here is one formula that works: (Count Column is just a column containing the number 1 because Countifs was not working with the same inputs)
SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Year Helper}, =2025)
Here is what I want to work, but is returning #INCORRECT ARGUMENT SET
SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Month/Year Helper}, =42025)
or
SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Year Helper}, =2025, {Month Helper}, =4)
I have checked my references, and they are correct and spelled correctly. Every time I try to add a 3rd range/criterion, I get error messages, even if they work individually. The helper columns are text columns containing formulas
EDIT As soon as I posted this, I went back to the sheet and all of the formulas are working. No idea what happened. I didn't change anything
Bill Raymond
Re: May Question of the Month - Join the conversation and receive a badge
That's a tough one, as my friends and family cannot even figure out what I do, even after I explain it!. I am a Business Analyst. I spend everyday working with 2 different software's: Microsoft Excel and Smartsheet. It is my job to create something new for people, as a project or report. Or to find a way to make their current process better. Better meaning, it has less errors, is faster, and the process is simpler. That is called Process Improvement, and once I do that cross-training can happen, meaning other people can learn that task. I am often called a Miracle Worker and Magician, as once I complete a new project, people still don't understand how I made it happen.
SherryFox
Show additional fields on bars and milestones in timeline view
May, 15, 2025
Users can now further customize their timelines by displaying additional fields on bars next to the bar’s title.
To configure this, sheet Admins can click on the new Show fields toolbar button in timeline view and in the right panel, select up to 4 additional fields to display on the bar. You can also choose whether a milestone’s date should be displayed next to its title. This long-requested enhancement will allow timeline admins to customize the information and level of detail on their view as needed for their audience and stakeholders. Learn More
Environments availability: Commercial US, Commercial EU
Plan availability: Business, Enterprise, Advanced Work Management
Subscription Model Availability: Legacy Collaborator Model, User Subscription Model
Stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Lekshmi Unnithan
Re: My formulas on my Metric sheet are calculating 0 and I'm not sure why
You are using a SUMIF function. This is used to add numbers together. It looks to me like you are more trying to count the number of instances in which case you would want a COUNTIF or COUNTIFS function instead.
Paul Newcome
Re: My formulas on my Metric sheet are calculating 0 and I'm not sure why
Happy to help. 👍️
Paul Newcome
Re: Welcome to the new AI Community!
- How long have you been using Smartsheet?
- Just over 3 yrs
- How are you using Smartsheet AI today or planning to in the future?
- I have yet to use AI but plan to in the future to help generate knowledge related to risks, common change orders, and applying lessons learned from various projects on new projects.
- What would you like to learn from your peers using AI?
- How you are using it to achieve the leverage of years of information to help address future work.
- Corey Freedman
Corey Freedman