Formula counting items in red and yellow

Answers

Kelly Moore ✭✭✭✭✭✭

10/06/22

Hey Sonia
Currently there isn't a way to remove the weekend days from being displayed in the view. Please submit an enhancement request. Here's a link that will allow the community to vote the idea up. https://community.smartsheet.com/post/idea/smartsheet-product-feedback-%26-ideas

Kelly

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…
Error message to
I am the owner of the sheet/workspace. I have given Admin Privilege to a few non-licensed users. One user was able to create a new report, and another user is getting this error message. Is this a Smartsheet issue?

Help shape the future of Smartsheet.
Share your ideas and feature requests.