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

  • Two new PPM Functions: Successors and isCritical, available now!
    In Formulas and Functions
    Hi Community,  We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical.  The Successors function (type: numeric) allows users to calculate the direct successors of a task…
    465 2
    Announcement 465 views 2 comments Most recent by Patti Petitclerc
  • Exporting a comma separated set of numbers in a cell to an indepedent set of columns
    In Formulas and Functions
    Hi All, I have something like this in a column QCEVCODE: 1,3,2,5,1 for let's say 1000 rows, each one of them is the amount of issues for a type of dataset. I need to be able to export this to independent columns (or any other way to happen…
    30 3
    Answered ✓ 30 views 3 comments Most recent by Genevieve P.
  • #Invalid Ref error in a report, but not the source
    In Formulas and Functions
    I'm seeing an invalid reference error in a report on a dashboard, but the source data is good and the vlookup is pulling in the data I want to see. Any thoughts on the cause/solution? I've narrowed down, deleted and re-created the cross…
    Answered - Pending Review
    53 3
    Answered - Pending Review 53 views 3 comments Most recent by Genevieve P.
  • Auto-assign task to next person on Contact list
    In Formulas and Functions
    I need to auto-assign tasks in a round robin style (i.e. the assignment goes to the next person 'in line' in the contact list). Is there a way to do this with a formula? I understand that tasks can be auto-assigned based on criteria in a s…
    664 16
    Answered ✓ 664 views 16 comments Most recent by Genevieve P.
  • Stacked Bar Chart using Metrics and multiple data sets
    In Formulas and Functions
    Hello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) …
    Answered - Pending Review
    28 2
    Answered - Pending Review 28 views 2 comments Most recent by Genevieve P.
  • WeekNumber & WeekDay error
    In Formulas and Functions
    Can anyone help with a way round the weeknum formula that starts on a Monday rather than a Sunday? I'm using the WeekNumber formula to get a current week in conjunction with the WeekDay formula to create a list of tasks due in a current we…
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by Nikki_Glass
  • trying to add a field to a logic flow
    In Formulas and Functions
    Hello, I have created a field "New Country". I want to use this in a logic flow "Country where work is being performed". The logic: If "other", then enter New Country. However, they system is not even sho…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P.
  • Basic checkbox counting to apply status option to Parent rows only
    In Formulas and Functions
    I am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exa…
    7 0
    Question 7 views 0 comments Started by Lotus
  • Formulae help
    In Formulas and Functions
    Hi Team, Can you please suggest on how do I write a formulae that can capture the All Client names separated by "," which are against Red status. The caveat is that the status can get updated periodically and hence today there ma…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Genevieve P.
  • Hello, I need some assistance with a forumla
    In Formulas and Functions
    I"m trying to set the status in a field to display blank "" if the Start date has not been reached. I'm using the following formula: = IF([Start Date]@row < TODAY(), "") I think this should work, but it is not. …
    8 2
    Answered ✓ 8 views 2 comments Most recent by Genevieve P.
  • What's wrong with this formula?
    In Formulas and Functions
    =COUNTIFS({Sheet - Sales Pipeline Range 1}, [email protected], {OD&I Pipeline tracker Range , "Pipeline")) It just reads UNPARSEBLE. Thanks Phil
    Answered - Pending Review
    6 3
    Answered - Pending Review 6 views 3 comments Most recent by Andrée Starå