-
Cross-Sheet Formula for Average of Column Excluding Blanks
I have three columns that are populated by column formulas. I need to calculate the average of each column and exclude blank cells in a different sheet. I appreciate your help! Thank you, Lori
-
Help with an Index/Match formula please
Hi All, Looking for some help with an Index/Match(if) formula please. Basically, if the value of a cell in column 1 = the value of a cell in column 2, then return the corresponding value which is situated in column 3. Please see attached screenshot for reference, I am working with dates across sheets. if a cell in DATE ID…
-
Trying to determine if all children have N/A Status
I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, "Complete", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 0, "Not Started"))) I want to add in…
-
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
IFs formula help
I have written a simple formula to pull the date from one column into another on every row of my sheet. ( =[Schematic Prep]@row)....converted to column formula. Now logically I understand that there are some projects in this sheet that must pull the date from a different column IF the "Survey Scope" Check box is checked.…
-
Reference a Page to calculate weight(Formula)
Hello Community, I am trying to reference a page which has certain weights assigned to the categories which the users will select while filling out the form. Based on the selection of the categories the weight is calculated and the total weight is shown. I am attaching the Screenshot of the page which has the categories…
-
COUNTIFS and DISTINCT
Hi there I'm struggling to get the syntax for a COUNTIFS(DISTINCT formula. I am creating a check sheet which counts only unique references against an SPV name. I have a list of the SPV names and I only want the check sheet to count unique references from the data input sheet with unique references and that match the…
-
Text to Traffic Light symbols
I am trying to turn text in a status column i have shuttled over using data shuttle from Excel into Smartsheet into a traffic light symbol. My column is Called Status, and the text in the column is green, yellow, red. I thought if i changed the column type smartsheet would identify this and convert to a traffic light…
-
How to Count how many times a cell is in a column
I am struggling with a formula how many times Delta appears in the Client Column. The formula I am using is: =COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))
-
Can someone help me with a date formula?
I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop. So if the end date is blank, the count will keep going up. If the end date is entered, it will show how many days passed between the start date and the…
