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 helpIn Formulas and FunctionsHow 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.
-
Work around for hiding rows?In Formulas and FunctionsAnyone figure out how to hide rows? I have a formula that blanks them out, but I would rather them hide and roll up.
-
Reference an infinite range starting from row xIn Formulas and FunctionsIs 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 …
-
using a calculated number of days in a workdays formulaIn Formulas and FunctionsHi 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 …
-
Embedding / Linking ImagesIn Formulas and FunctionsHi, 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.
-
setting date parameters in cross sheet formulasIn Formulas and FunctionsHi, 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…
-
Counting party size from SymbolsIn Formulas and FunctionsI would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Process DurationIn Formulas and FunctionsI'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. …
-
Countif formulaIn Formulas and FunctionsHello 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…
-
Enter duration as "Net Days" but still count work days without Sat/Sun.In Formulas and FunctionsUnder 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…
