Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Formula help
    In Formulas and Functions
    How would i add the children rows, that has the below sum? Grandparent - SUM??? Parent - ="Total: " + COUNTIF(CHILDREN(), 1) Child - Tick box   Hope this makes sense.     
    1 4
    1 view 4 comments Most recent by Marcus Odum
  • Work around for hiding rows?
    In Formulas and Functions
    Anyone figure out how to hide rows?  I have a formula that blanks them out, but I would rather them hide and roll up.
    552 6
    552 views 6 comments Most recent by J. Craig Williams
  • Reference an infinite range starting from row x
    In Formulas and Functions
    Is there a way that would enable me to reference an infinite range starting from, for example, the 5th row down.   Currently, my solution is to use indents and use the CHILDREN([Columnx]x) function. HOWEVER, unfortunately it seems like …
    61 9
    61 views 9 comments Most recent by [email protected]
  • using a calculated number of days in a workdays formula
    In Formulas and Functions
    Hi Im new to smart sheets - so thx for helping newbie Im trying to drive a planned finish date i use the workdays formula - grab the planned start date, then try to add the number of days from a calculated field (called Suggested Number …
    11 2
    11 views 2 comments Most recent by Paul Newcome
  • Embedding / Linking Images
    In Formulas and Functions
    Hi, I was wondering if there is a way to embed/link an image to present itself in the cell if that cell was to presented as 'true'. I want to be able to tick a checkbox and for the 'true' value to present an image. Thank you.
    13 5
    13 views 5 comments Most recent by [email protected]
  • setting date parameters in cross sheet formulas
    In Formulas and Functions
    Hi,   I am looking to pull rolling data onto a dashboard. i have the cross sheet formula working well however i am looking for some help with an addition to this. I would like to add to the formula to look at data for the past 30 days f…
    11 1
    11 views 1 comment Most recent by J. Craig Williams
  • Counting party size from Symbols
    In Formulas and Functions
    I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?   
    11 1
    11 views 1 comment Most recent by Marcus Odum
  • Process Duration
    In Formulas and Functions
    I'm looking to find the change in process duration before and after a process improvement project. I'm asking for the length of 1 unit of work both before and after a process improvement effort (in Hr:Min:Sec.) What I need is the change.  …
    1 1
    1 view 1 comment Most recent by Marcus Odum
  • Countif formula
    In Formulas and Functions
    Hello I have a sheet that tracks number of days we are over or under staffed with a -2, -1, 0, 1, 2 I would like to add a criterion that it only counts the days that are after today. Here is the formula that was recommended by Smartshee…
    61 3
    61 views 3 comments Most recent by J. Craig Williams
  • Enter duration as "Net Days" but still count work days without Sat/Sun.
    In Formulas and Functions
     Under project settings I want to make Saturday and Sunday as working days so "Hard" products would follow a timeline that includes weekends. A task starting on October 1st with a duration of 31 days would end on Oct 31st.  I al…
    31 1
    31 views 1 comment Most recent by J. Craig Williams