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?