-
Notification/Reminder for Past Due Task
I have reviewed the many questions asked previously by others regarding Notifications and Reminders as relating to dates and I am either not understanding them or they are different enough from my application that I don't feel the solution is applicable. I am simply attempting to send an e-mail to an individual whenever a…
-
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.