-
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me. My question is, is there an automation or a formula where when it is moved back to…
-
Formula countifs mulitiple criterion?
Hi, I can get as far as (made up example) =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass") but I need to get a third items to be count. For example: =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass", {Range 8}, "ready") Is it possible to search three different columns in a crossheet countifs? Thank you, I appreciate any…
-
If two conditions are met, then copy the value.
Hi Smart Team, I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the…
-
Create Running Average
I need to create a new column with a running average based on the duration column, sounds simple, right? NOT! The issue is the data. In the screenshot below, shows the first section. In this instance the 2nd record shows the end date that happened first. So, as a result, that running average would be ONLY that one record.…
-
COUNT AND SUMIFS ... TO NOT INCLUDE CERTAIN CRITERIAS
Hi, I am wanting to =countif({Postcode 2}, does not contain any of the listed postcodes .... and then the same for a sumif however my brain is not working :( help please :)
-
Get comma separated values from a cell and copy the values into independent cells
I have a column: "Materials QTY" values in this cell: "10,5,100,1400,11000,2" (comma separated no spaces). I have independent columns ie. "Material 1 QTY", "Material 2 QTY", "Material 3 QTY" up to 20. I need to extract the 1st value from the "Materials QTY" and populate it in "Material 1 QTY"; the 2nd value from the…
-
Multiple contacts in a sheet summary field
Hi, We use control center and we love using Sheet Summary field to bring in certain values from Specific Sheet (using cross-sheet reference formula) then we feed that info to column with column formula so every row will have the same info. We noticed we can't do this for Multi-Select Contact in Sheet Summary if column type…
-
SUMIFS Formula Assistance
I have a sheet in which I want to SUM a column of data if the status is equal to a value and the year is equal to 2023. It seems to not like my year criteria =SUMIFS([SaaS Value]:[SaaS Value], Status:Status, "Active", Year:Year, "2023") Specifically I am getting an invalid data type error
-
How to ignore (0.00) when using SMALL Formula
I have 3 columns and each row I would like to return the smallest number. If one of the three columns contains a zero then I would like to return the NEXT smallest - essentially ignore the zero (0.00). How do I accomplish this?
-
Index Collect including Cross Sheet Date Comparison - Formula Help
I have two sheets. On the current month's data (#2 below), I am trying to pull in previous treatments from the Historical Patient Treatments (#1 below) Historical Patient Treatments Treatment - Name of Treatment - {Treatment} Acct - Customer Account {Acct} MRN - Patient Medical Record Number {MRN} Newest - A checkbox…
