Formulas
Discussion List
- Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it …
- Hello Community, I have a formula setup to count the number of times a contact is mentioned in another sheet, but it is not counting the rows with multiple contacts in the cell. Is there any way we ca…
- 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 …
- 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", …
- 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…
- 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 …
- 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 :)
- 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.…
- 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 formul…
- 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:…
