-
Sheet summaries OVERALL average
I was able to resolve a #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0). However, I am currently hitting a road block on getting an accurate average from my sheet summaries. Is there a way to get an average of all summaries not labeled OVERALL that will only…
-
Adding an IF statement to a formula
I'm using the formula below to subtract numbers in two columns and provide the answer in a third. Some of the cells in the first column don't have numbers (there are words) so I am getting an #INVALID OPERATION error which I expected. I want to add an IF statement to the formula to return "0" in place of that error (not…
-
Formulas Question - Referencing Another Sheet
Good morning, I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects. I basically want to say what is the average of the duration fields if the phase is completed and the end date column is in the month of…
-
Using CountIfs to track a column will multiple options
Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts all instances? Formula below for example =COUNTIFS({Training Project Task List Range…
-
Is it possible to have a Start/End date on the same line?
I was created a request form for the office and I have to put a Start/End date option for this request. Would it be possible to have those options on the field line instead of different fields?
-
#DIVIDE BY ZERO Error message
The below formula is being used to count items (Installed) & items (Complete) against a cell value (Protection plate) in a sheet summary to produce a %percentage (Complete). The is being used in multiple sheet summaries to compile an overall %percentage (Complete). The formula works great, however if the column [Protection…
-
Absolute reference
I want to use absolute reference for a cell. However, when I select the cell, I always get the @ row at the end. For example, when I select the cell [Text Text], I get [Text Text]@row. Do I have to always manually specify the cell number when I want to use absolute reference?
-
Why is this formula not converting to a column formula?
Hi, I have set up this formula and am trying to convert to a column formula but it tells me there is an error and it won't do it. How do I change it so that it works? Also would there be a more efficient way of writing this formula? Thanks! =IF([Month No]@row = 1, [PO #]$1, IF([Month No]@row = 2, [PO #]$1, IF([Month…
-
Sheet Summary Formula for Number of Tasks Complete (Not Started, On Hold and In Progress)
Looking to find a formula for number of tasks in each status- I have this so far but I'm getting the #UNPARSEABLE error. Please help =COUNTIFS([Status]:[Status], CONTAINS("Complete" @cell)", [%Complete]: [%Complete], 1)
-
Formula
Hi everyone, I have a form going were people add rankings. I am trying to compare in a seperate sheet the latest two entries. Is there a way that I can tell smartsheets to always pick the lates two entries from another sheet? I know how to pick the latest but I am not sure about how to pick the two most recent ones.