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
-
Importing Google Finance Data into Smartsheet?In Formulas and FunctionsHi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existi…
-
Importing/Syncing Excel FileIn Formulas and FunctionsI have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a …
-
Task ConstraintsIn Formulas and FunctionsHow to you apply constraints on tasks eg. Must finish by, start on etc.
-
Check cell range and compare against date today()In Formulas and FunctionsI 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 form…
-
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…
