-
Using decision symbols: Yes, No & Hold
Hi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following parameters: If [Status@row] is equal to "Submitted" or "In-Progress" and [Created@row] (date)…
-
Track minutes
Hello, Can I please just confirm the only way to track hours & minutes in a sheet is by paying for either the 10,000 feet or Bridge add on? Thanks, Charlotte
-
Formula with range that goes from a certain row to whatever the current bottom row is
My formula: =AVG(COLLECT(IIQ28:IIQ99, [SE Manager]28:[SE Manager]34, "John Lennon")) First, I cannot use the entire column. There is data in rows 1-27 that can not be applied to my average. I want the range to go all the way to the bottom of the sheet, because this sheet is regularly populated by a workflow from another…
-
Can I use a Join when trying to create a report from 2 sheets
I want to "Join" the data from one sheet to the other sheet in a Report using the Primary Field so that I only get 1 ROW with all the columns filled in. Instead, I get DOUBLE primary each with data populated only from the Sheet it came from which isn't useful at all. Is this possible?
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…
-
Formula issue
Hi Can someone help me to write these five formula in a single formula to get the schedule health. IF(Status@row = "Not Started", "Gray") IF(Status@row = "On Hold", "Yellow") IF(Status@row = "Not Applicable", "") IF(Act1@row >Act2@row , "Red") IF(Act1@row <Act2@row , "Green") THanks
-
Formula not working
Hi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Progress - Red else Green =IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On…
-
"Make owner" using API
Hi, everyone. I want to change ownership of 100+ sheets that I own using the Smartsheet API. I have been looking through the documentation and could not find how to do it. According to this post on stackoverflow it is not possible. Performing this actions within Smartsheet interface is really tedious because you need to go…
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…
-
formula not working on row1
Hi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 Thanks