-
Status Roll Up Formula
I am working on a sheet to track the status of test cases and want to have the status of the subtask roll up to the parent status. The goal is that if 5 tasks are available and 2 "Passed", 1 "In Progress", 1 "Not Started" and 1 "Failed that it shows the status of "In Progress on the parent row. Below is the formula I am…
-
VLOOKUP and/or COLLECT/ JOIN?
Hi! We'd like to have visibility to all clients associated with a given person. Here's a simplified example. Current Data: Here's the result I'm looking for on a separate sheet - where the Primary Name is populated via an external form, and a formula looks up the Primary Name and collects all Clients associated with the…
-
Trouble shooting a INDEX/MAX/Collect formula with an IF statement
So this is the weirdest thing - at least for me. The same formula works great for one column, but not for the other. It works fantastic here: =IF(COUNTIFS({DAX Ambient Inventory Range Install Date}, ISDATE(@cell), {DAX Ambient Inventory Project #}, [Project Number]@row) > 0, INDEX(MAX(COLLECT({DAX Ambient Inventory Range…
-
Count Query
Hi, I have a sheet that tracks Daily attendance. I have a 'Name' field and 'Date' field. How would I gather a daily and weekly count of unique names? Furthermore I have a 'manager' field - Is it possible to provide a daily total for each time the managers name appears in this column. Thanks
-
COUNT but not if duplicated in another row
Hi Looking for some help with a formula... really not sure where to start. I have a sheet where each line relates to scaffold that has been built which is populated by a webform. Each line has a tag number and if I count all the tags in the column Tag No, I can see how many scaffolds are in place. The webform also collects…
-
Adding two different criteria together which are found in the column
I am trying to add up how many times "INVENTORY" is used in my column and how many times "READY2SHIP" is used in the very same column. I tried sumifs, countifs, but none of these seems to work. Could you please assist me? The same column has several status. Only one status applies per row. I want to see how many times I…
-
Multiple sumifs
=SUMIF([Platform Site]@row, CONTAINS("eBay", @cell), Net@row - [PayPal Fee]@row) =SUMIF([Platform Site]@row, CONTAINS("fsx", @cell), Net@row - [Platform Fee]@row) These work independently but I need them to work together for a column formula. When I try to put them together, I keep Error messages. Help. I have to have this…
-
Calculate Harvey Ball if another field is "yes"
I have a Text/Number field, which is "yes" and "no". I only want the Harvey Ball to calculate on the %complete field, if the answer to my Text/Number field is yes. If no, I should not populate anything in the Harvey Ball field. Can I do this? Otherwise I could try an grey the field out with formatting. Thoughts? Thanks so…
-
Checkbox formula based on 2 columns matching
Hello, I'm sure i'm creating extra steps for myself on this but here is my issue at this time. My goal is to set up notifications on one smartsheet when there is a manager change on the master smartsheet. I broke it down into steps. First, I created a formula on the smartsheet I want the notification to populate. I have my…
-
SumIF Cross Sheet
I am simply trying to summarize AR data for a dashboard on a summary sheet. I need to know the balance due for each company totaled up. Below is one of many attempts I have tried. There are only six options so I canmanually update the formaula for each company but that didnt work either. What am I messing up? Thank You