-
Task Constraints
How to you apply constraints on tasks eg. Must finish by, start on etc.
-
Check cell range and compare against date today()
I have looked through and tried to apply several solutions and none seem to work with a range of cells. I have a date/time field column under and have entries in several different collapsible fields. I am in need of help creating a formula that will check all the cells in the range/in the collapsed range (are they children…
-
Formula help
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.
-
Random function
I'm looking for functionality that would enable a field to be completed with a random selection from a list. Is this something that exists within Smartsheet? I cannot seem to locate any formula code to accomplish this. In excel we would use a random integer nested in a VLOOKUP function that would generate a random number…
-
Work around for hiding rows?
Anyone 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 x
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 this is not a solution compatible with webforms. Is there a way that I can do this, that…
-
using a calculated number of days in a workdays formula
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 of Days) which calculates a number of days based on some inputs (e.g. 100/10 = 10) but…
-
Embedding / Linking Images
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.
-
setting date parameters in cross sheet formulas
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 for one column and the past 60 days for another column. i am hoping this is pretty straight…
-
Counting party size from Symbols
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?