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 Functions
    Hi 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…
    325 3
    325 views 3 comments Most recent by Andrée Starå
  • Importing/Syncing Excel File
    In Formulas and Functions
    I 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 …
    850 2
    850 views 2 comments Most recent by Andrée Starå
  • Task Constraints
    In Formulas and Functions
    How to you apply constraints on tasks eg. Must finish by, start on etc.
    155 1
    155 views 1 comment Most recent by baddams
  • Check cell range and compare against date today()
    In Formulas and Functions
    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 form…
    450 8
    450 views 8 comments Most recent by ateleoh
  • 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.     
    2 4
    2 views 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.
    1093 6
    1.1K 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 …
    86 9
    86 views 9 comments Most recent by L_123
  • 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.
    15 5
    15 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…
    12 1
    12 views 1 comment Most recent by J. Craig Williams