Formulas
Discussion List
-
COUNTIFS counting mismatchIn Formulas and FunctionsHi folks, Any help appreciated with this...I have some miscounting and can't seem to work it out...arrrgh! If I filter my main sheet as follows: The result is a count of 16, which is correct. However, my formula to achieve the same on a su…
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire columnIn Formulas and FunctionsHello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula u…Answered - Pending Review 29 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Unparseable error with "IF"In Formulas and FunctionsGood day everyone, I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here. Here's the formula that I'm using: The thing what I want to do is if the Grow…
-
Create a list from check marks in a gridIn Formulas and FunctionsI need to pull data from a grid organized like this (with yellow items being being column headings): into a list that is structured like: I am stumped on how to do it. I do not own the original data so I cannot restructure it into a diffe…Answered - Pending Review 26 views 4 comments 0 points Most recent by Matthew Barrett Formulas and Functions
-
SUMIFS with Multiple Conditions and Two Children RowsIn Formulas and FunctionsHi! I'm trying to work out the SUMIFS formula for a summary sheet based on multiple criteria that will SUM from two different children sum rows. Row 3 and Row 42 have the SUM(CHILDREN()) formula in those columns. I can do it for one chil…Answered - Pending Review 3 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Error in WEEKDAY formulaIn Formulas and FunctionsI'm struggling with a formula that seems to be broken. I created a timesheet that has a cell that looks at the Auto Date/Time stamp and calls up the weekday. The formula is as follows: =WEEKDAY([Date/Time]129) It works great...unless th…
-
SUMIFS I think?In Formulas and FunctionsI am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is:…
-
Formula to return different valuesIn Formulas and FunctionsHello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF([email protected] <…
-
FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SETIn Formulas and FunctionsHello, I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formul…
-
Sheet Name within a CellIn Formulas and FunctionsHello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i n…
