-
Importing Google Finance Data into Smartsheet?
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 existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…
-
Importing/Syncing Excel File
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 solution to be able to update my master sheet. Importing doesn't work as it creates a…
-
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.
