-
Formula Question See Below
IF PDCA range 4 finds ( anywhere ) "Monkeys" , and you can find "OK 3" in Range 1 return a BLANK but if it cant return 1 =COUNTIFS({PDCA Range 4}, HAS(@cell, "Monkeys"), {PDCA Range 1}, FIND("OK 3", @cell) = blank)
-
Looking to create function that counts rows only when 2 conditions are met from different rows
I have two rows in question, one containing a list of states, the other containing a list of "types". I am looking to create a function that only counts rows that satisfy 2 specific criteria. For example, only count rows that contain State = Colorado AND type = payment. To make things more complicated I am referencing the…
-
When setting up cell links, is there a way to not have to set each one up one by one?
I am using a master log for incoming service requests. Once marked "logged" and saved, the row is copied to a 2nd sheet for me to use as my task list. I want any status updates on my identical 2nd sheet to be reflected back on the master log. I can only see a way to do it one by one as new rows are copied over. Any…
-
SUMIFS Formula
I am attempting to get the sum of two separate columns Number of Participants Reached (Adults) + Number of Participants Reached (Students) for FY 2021 only All 3 sets of numbers are in different columns I can get the total sum of the two columns right for all years but I can't figure out how to have it only calculate for…
-
Rows to reference Columns
Hi, I have a Form that adds rows to the Consignment Stock Take sheet (seen below). Inventory items in this sheet are arranged by columns. Furthermore, I have an Inventory Management sheet (seen below) which has Inventory Items arranged in rows. Problem/Desired Outcome I want the [In Stock] Inventory Management Column to…
-
Flag is others are flagged
I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the "Planning" phase are flagged. I was attempting to use a formula like this: =IF([At Risk]95:[At Risk]98 =…
-
Incrementally increasing a number daily in a cell
I want to have a number incrementally increase by 1 each day until a checkbox is selected in another column. There are 2 columns named: Days Lost (Column type Text/Number) Team Restarted (Column type Checkbox) If I put a 1 into a cell (Row 1) in the Days Lost column, I want it to change to 2, the following day. If the…
-
Compare 2 Multi Select Drop Down Columns
I have 3 columns, all have the same multi select drop down options. I want the first column to be my selection, the second column is more of a checklist of what's complete, and the third column tells me what is left to be completed from the first column. Any idea if this can be done? Tried using collect formula.
-
How do I average children?
Please help! I am trying to come up with a formula to put in the parent row to get the average % completionof the children row. My children row % percentage completion are filled in using this formula: =(IF(Pulled@row, 0.5, 0) + (IF([Source Termed (FROM)]@row, 0.2, 0) + (IF([Device Termed (TO)]@row, 0.2, 0) + (IF([Source…
-
Counting Items as Singles in a Multi Select Drop Down Column
Hello Smartsheets Community: Does anyone have a simple solution to count items as individuals when using a Multi Select Drop Down Column. In the screen shot below, we have a column where we put the potential customers we think we are going to sell a new product. What I would like to do is be able to accurately reflect…