-
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.
-
Ancesstors
I can use the below formula to get the ancesstors + task name JOIN(ANCESTORS([Task Name]@row), " | ") + " | " + [Task Name]@row This will return to me: Parent 1>Parent 2> Parent 3> Task 1 I'd like it to return the reverse order: Task 1> Parent 3>Parent2>Parent 1
-
Sheet Summary - Show completed tasks and status
Below is an example of one of my sheets in smart sheet I would like to add a sheet summary that : Shows the status of the overall project automatically ( in Green/Yello or Red) by calculation, as in looks to see if the status of the items that were supposed to be finished in the last two weeks are Done and if the status of…