Formulas and Functions
Archives for April 2018
Discussion List
-
Formula to count rows in a date range across columns and statusIn Formulas and FunctionsI am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Dat…
-
Adding a Title to a COUNTIF formulaIn Formulas and FunctionsI am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have for the parent row: ="May 201…
-
Cross-sheet "countif" formula with three criteriaIn Formulas and FunctionsI am struggling with another Countif formula. I have a working formula in one column that counts proposals filtered by month and year. I am trying to modify it to add another criteria so I can count proposals filtered by the month year t…
-
SUMIF no error, but returns '0' vs. actual sumIn Formulas and FunctionsI'm using the Sum =SUM(CHILDREN()) to capture scoring of items by various teams, which is working great for each tool/category, but I want to now show a score by team (not just overall total by tool). =SUMIF(Tool6:Tool187, "Developm…
-
countif to total summary two different values into oneIn Formulas and FunctionsI have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS. So…
-
Need Help with a formulaIn Formulas and FunctionsI'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.
-
IF(AND) Syntax QuestionIn Formulas and FunctionsI am trying to correct the SYNTAX for the below scenario as I repeatedly get #INCORRECT ARGUEMENT SET as a result on line 3. In the column labeled "Today" I have the following formulas: LINE 1 =IF(MONTH(TODAY()) = [DOJ Anniver…
-
Capturing a Total Count to display in a DashboardIn Formulas and FunctionsI am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "…
-
How to concatenate two functions in a single cellIn Formulas and FunctionsI want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65-K65 &","& I65-L65 but in smartsheet when I try the same like =[Next month Pro…
-
Nested IF using additional AND logical functionsIn Formulas and FunctionsI am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages. My formula is right now as follows: =IF(ISBLANK([RESPONSE DATE]88); "Gray&…