-
R,Y,G and G - Part 2
Hey @Paul Newcome / @Andrรฉe Starรฅ , Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request. . In a nutshell, at the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there isโฆ
-
Is there a formula for the "people/resource" symbol measurement?
-
COUNTIFS Formula For Total Number Of Assigned Projects To Individual
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which [Assigned To (In-House Designer)] is "Danielle Morrison" AND the [Request On Hold] checkbox in UNCHECKED. Background Information: The Assigned To (In-House Designer) column type is a Contact Listโฆ
-
Flagging newly created duplicate rows
Hi, I am using a sheet to maintain incoming requests for a system access. However, in case there are multiple identical requests, I only would like to trigger the associated workflow for the request that came in first. I have used a formula to flag all the duplicate rows but is there a way to exclude the row that came inโฆ
-
If function for priority
Hello, I am working on trying to come up with an IF function for priority. An example would be IF the cell is high priority (Red exclamation point) then the number 1 is given, but if it is medium priority (Yellow line) 2, or if low priority (Blue down arrow) 3 is given. These flag images can be changed if needed, it wasโฆ
-
IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)
Hello, I am trying to troubleshoot a formula to achieve the following outcomes. Outcomes: If the Due Date column is past today's date, trigger a flag in the "Past Due" column. HOWEVER: If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column. Databaseโฆ
-
How can I get a due date to automatically populate in a cell 10 days from the day a row is created?
We currently use a sheet to track warranty construction items. A form automatically creates a new row under our warranty sheet with columns such as due date, claim number, item, address, name, email and so forth. When this row is created by a form being filled out we want the due date column cell to automatically generateโฆ
-
Column CountIF Totals won't plot on Chart Widget when summarized
The Goal: I built a Dashboard Chart Widget to present Summary Data and found it works when I pull from a Column Total that uses a Count formula that is then Totaled with a simple addition formula. =COUNT([High School]3:[High School]124) =[High School]2 + [High School]125 + [High School]172 + [High School]212 + [Highโฆ
-
OR Syntax
Hello Community, What's wrong with my syntax below: =COUNTIF(OR([Column 1]:[Column 1], CONTAINS("A", @cell)), [Column 1]:[Column 1], CONTAINS("B", @cell)) If it's not obvious, want a count from Column 1 when "A", or "B" are present. Error is "#INCORRECT ARGUMENT SET" if it helps. Jason
-
#UNPARSEABLE error on trying to return a "red", yellow", "green" dot symbol
I'm trying to get Smartsheet to return a "red", yellow", "green" dot symbol to track the health of my data. Right now, my formula looks like this: =IF(COUNTBLANK([New Project #]1:VOLUMES1) = 0,"GREEN",IF(COUNTBLANK([New Project #]1:VOLUMES1)<7,"YELLOW","RED"),"RED") where: [New Project #]1:VOLUMES1 contains 15 cells in aโฆ