Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • Report Grouping based on Multi-Select Drop Down, with the same "data" listed under multiple groups
    In Formulas and Functions
    I have a list of technicians who support calls from different phone queues. I need a report that will group all technicians who support each one. And as in any call center, technicians never support a single queue and will therefore need…
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by bonzemail
  • Countifs and check boxes.
    In Formulas and Functions
    Good Day, I keep receiving unparseable/ errors for this formula. I've typed this 20 different ways. I'm very lost at this point. =IFERROR(COUNTIFS({Oil Change Tracking Range 1}, [Zone:]@row, {Oil Change Tracking Range 2}, [Service Date:…
    Accepted
    10 3
    Accepted Answer 10 views 3 comments Most recent by Paul Newcome
  • Date Validation
    In Formulas and Functions
    We're tracking Open Enrollment for multiple clients on one sheet (below just includes one client). I have played with helper columns trying to find a way compare these dates with no success. Since they are on different rows, getting them t…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Marvin Daniels
  • Lookup formula still available?
    In Formulas and Functions
    Hi there! Is the Lookup formula still usable in Smartsheet? I'm trying to do a lookup within a matrix of values, where I need to specify both a horizontal and vertical lookup criteria. From what I've found, it looks like Lookup would've be…
    Answered - Pending Review
    17 5
    Answered - Pending Review 17 views 5 comments Most recent by Paul Newcome
  • Tracking Changes in Scores Over Time
    In Formulas and Functions
    We track changes in PHQ-9 and GAD-7 scores for patients who have a certain number of collaborative care appointments. I want to show an aggregate widget on the dashboard for all active and relapse prevention patients, which would mean calc…
    Unanswered
    11 0
    Question 11 views 0 comments Started by Courtney Coules
  • Is there a way to add/edit responses to a form without creating a new submission?
    In Formulas and Functions
    I'm wondering if there is a way to create a form that has a "save" button instead of "submit" so that the user can return at a later time to complete questions? I want to be able to use the form as a working document fo…
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå
  • $ Formatting not rolling up in Report Summary / Dashboard
    In Formulas and Functions
    I have a report that is has a summary of US$ formatted amounts, however the summary amount only shows a number; it doesn't inherit the US$ formatting and there is no means to change it. When this summary data is presented in a dashboard it…
    Accepted
    9 3
    Accepted Answer 9 views 3 comments Most recent by Andrée Starå
  • Countifs after a date
    In Formulas and Functions
    I am trying to count the number of closed opportunities for the 2021 calendar year that meet the criteria of: Won AND is of market sector offices new. I have used the formula below but it's not working. Where have I gone wrong? =COUNTIFS({…
    Accepted
    14 3
    Accepted Answer 14 views 3 comments Most recent by Lidiya S.
  • Find the next due date if task not complete
    In Formulas and Functions
    We have reassessment tasks that are required every 3 months (3, 9, 15, 21) and every 6 months (6, 12, 18, 24). I would like a column to inform me what the next 3M and 6M due dates are. Therefore, I need to pull the soonest due date if the …
    Answered - Pending Review
    22 2
    Answered - Pending Review 22 views 2 comments Most recent by Tessa Frank
  • How do i populate data from multiple columns to a single column
    In Formulas and Functions
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Paul Newcome