Formulas
Discussion List
-
How can I convert text names to existing contacts in my account?In Using SmartsheetI manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed…
-
Dashboard chart for daily submissions (via form) over timeIn Using SmartsheetI have a seven week event. I have a form set up for submissions about the event. How do I set up the metric sheet and which formulas to count submissions each day/ week to appear on the chart to show on the dashboard.
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Issue with Index Collect FormulaIn Formulas and FunctionsLooking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response fro…
-
Formula to count a value within a given rangeIn Formulas and FunctionsI am trying to write a formula that must meet (2) criteria and then count the number of values that are: <500 =500 and <=999 ( this is the formula I cannot write for some reason) >999 I have been successful at pulling the two crit…Answered - Pending Review 19 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Reference Predecessor Cell / INDIRECT FunctionIn Formulas and FunctionsI'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My …Answered - Pending Review 27 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Question on Value functionIn Formulas and FunctionsHello. Using this formula, =IFERROR(VALUE(LEFT([Time to Close (Bus Hours)]@row, 3)), IFERROR(VALUE(LEFT([Time to Close (Bus Hours)]@row, 2)),VALUE(LEFT([Time to Close (Bus Hours)@row, 1)))) I'd like to be able to take a string that co…
-
Why am I observing this odd behavior with a "Created (Date)" column?In Formulas and FunctionsI think I've found a bug. I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column. DATE TEXT = Date + "" DATE TEXT is calculated by…Answered - Pending Review 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula to count days past due but leave the column blank if the task is completedIn Formulas and FunctionsHello, On my sheet I have tasks that have a column for Due Date, Completion Date, and Checkbox for Done. I want to keep track of the tasks that are overdue and have an easy way to glance and see how many days they are over due from the du…
-
Count+DistinctIn Formulas and Functions=COUNT(DISTINCT(CHILDREN())) I using the formula above to count the distinct number of bays for different shipments, some shipments would have all of the bays in one cell. Is there a way to modify this formula to count the bays within one …Answered - Pending Review 14 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
