Formulas
Discussion List
-
Easy way to count unchecked boxes in a columnIn Formulas and FunctionsHi there, I'm trying to create a reference that counts the number of unchecked boxes in a column from one of my form-filled Smartsheets. I'm trying to use the formula "=COUNTIF([column2]:[column2],=false)", where "[colum…
-
INVALID DATA TYPE error when using MONTH()In Formulas and FunctionsHi, I'm working on a formula that will use a date to reference a value in another sheet: The sheet that will be referenced looks like this: I'm planning on using INDEX and MATCH to get a date value from a row in the first sheet to return a…Answered - Pending Review 22 views 6 comments 0 points Most recent by Faheem Shameem Formulas and Functions
-
Using CountIF function to calculate Count of MarketIn Formulas and FunctionsHi! I'm looking to get some help on a CountIF formula. I have a sheet "Territory 4 Exit Interview Pivot Table" which I am looking to get a count of how many employees are in Market 41, 42, 43, and 44 (from the T4 Exit Interview …
-
How can I subtract a changing number of days from a date?In Formulas and FunctionsHi there, I have a "Due Date" column and an "Order By Date" column. The Order By needs to reflect a date that is the Due Date minus our lead time (reflected in a third column and listed as a number of days). The issue…
-
COUNTIFS/CONTAINS FUNCTIONIn Formulas and FunctionsHi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
-
CountIF Formula Help for DashboardIn Formulas and FunctionsSee screenshot. I want to create a graph on a dashboard that shows how many total rows on the sheet pertain to Medical, Fire, and/or Police (indicated by checkbox columns on each row). Will I need to create an Agency Name sub row for eac…Answered - Pending Review 9 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Calculating SUM based of criteria from multiselect.In Formulas and FunctionsGood day, I have a form with quite a few multi selects. After a user selects all that apply, I want to cross reference what he selected with a second sheet that has "costs values" associated to the same text that the user had ava…Answered - Pending Review 12 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
What value does MATCH return if it matches nothing?In Formulas and FunctionsOr possibly my question is what is the null value in Smartsheet. And does it matter if the context is boolean or not? Thanks.Answered - Pending Review 9 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Incorrect field value in email with Smartsheet automationIn Formulas and FunctionsHi, I see an issue in automated email if we use a Date column with formulas. In my sheet, I have a Date type column (CreatedDateTime) with formula [email protected]+"". So, When a row is added, this cell shows the Date and time based…Answered - Pending Review 16 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
IF Formula assigning scoresIn Formulas and FunctionsHello, I have a formula (below) that assigns scores depending on a criteria and whether or not the checkbox is checked. I.e. If the Governor's Dashboard is checked, it will assign 4 points to the total project score. I have one item that…Answered - Pending Review 17 views 2 comments 0 points Most recent by Maria Watters Formulas and Functions
