-
Rows Weighted Differently for % Complete of Parent Task
We have a bunch of tasks in our smart sheet timeline that are weighted differently to determine the percent complete of a parent task. Am I somehow able to say that row 5 is only 20% of the parent task, but row 6 is 40% of the parent task, and have that calculate towards the total percent complete of the parent task…
-
Using COUNTIFS to automatically assign new rows to a person based off criteria
Hey all, I am working on a way to automatically assign newly added rows to a sheet based off a certain criteria. We have two managers. I'd like new rows to automatically assign to one manager then the other based off different scopes of work from a multi-select column. For example, I can only input 8 types of jobs and 8…
-
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…