-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-β¦
-
Countif Formula to include Flags
Hello, I have a cross-sheet formula pulling in dates and other data from various sheets; however, I can't figure out how to count if the column contains a flag. The formula is summing all new hires who have a status containing "push". =IF(Level@row < 2, SUM(CHILDREN()), IF(Level@row = 2, COUNTIFS({New Hire Push List -β¦
-
Is a daily entry missing?
We use a form that allows each of our 120 stores' managers to input some data at the end of each day. Is there a way for me to see which stores missed a day? Each form entry requires the store name (drop down), and I have another sheet that has every store listed in it. Trying to think of a way to have aβ¦
-
Change Color or the Harvey Balls/ Status Icon
Hi Team, I need to change the RYGB to add another 2 set of Colors for Gray and Purple and show as RYGBGP Because, in my formulae, if I type Purple, it doesn't populate the Ball icon of this color, just returns Text. Is this feasible in Smartsheet Thanks!
-
summing values across sheets
I have 3 metrics sheets I would like to amalgamate and add sales figures in a central sheet or report. ie adding sales for the month from multiple locations. How do I do this as when I use the =SUMIFS({Quotes Client Master 2020 onward & Confirm Range 4}, {Quotes Client Master 2020 onward & Confirm Range 1}, "Emer", {Quotesβ¦
-
RAG status help
I am trying to right a formula to give a RAG status based on 6 columns of check boxes. I want Green for all boxes ticked, Yellow for some, and Red for none. This is the formula I have but it comes up as Unparseable =IF(COUNTIFS([PTC CRBA]@row:[PTC Aud]@row, 1) = 6, "Green", IF(COUNTIFS([PTC CRBA]@row:[PTC Aud]@row, 1) < 6,β¦
-
Collating Data
Hi :) I have a long form that asks a heap of questions and if the answer is "no" then more details need to be provided, i need to pull all of the extra details back into a different register but have them stacked vertically and separately (see example below) is there a way to do this ? Snip 1 : This is what the form looksβ¦
-
How do you reference 'Created' column date of a PARENT and add one calendar year?
Hi all, I am trying to do the following: For a given cell, I would like to reference its Parent's Created date and return a date that is one year in the future. I think I'm just struggling with finding the correct syntax.
-
Using a profile matrix to drive automation on specific dates
I have a profile matrix that has a set of dates across the top (columns), row 1 and then a list of product types (Student, Teacher, Classroom) for each record, starting at row 2. On a separate sheet I have a list of products that associate to the various product types, i.e. Student Workbooks (Student), Instructional Manualβ¦
-
COUNTIFS with COLLECT?
I am trying to use the COLLECT function, wihtin a COUNTIFS, to count cells that contain numbers and fall within range of percentages. I feel I am close in that I get an Incorrect Arguement error rather than Unparseable. Any advice? =COUNTIFS(COLLECT({CP Complete 1}, ISNUMBER(@cell), >=0.9, <=0.8, {Go Live}, >=DATE(2021, 4,β¦