-
Sheet Template; Not all Formulas Carry over
When using a template, why don't formulas copy over, even when I leave a dummy row in with the formulas, the new sheet doesnt carry the formiula on the next inserted row. I could have swore that previously, when you inserted a new row the formulas would pre populate.…
-
JOIN(ANCESTORS()) example
In the Formula Help template (v2.0, line 109), there is an example of using JOIN with ANCESTORS https://app.smartsheet.com/b/launch?lx=ZRqX2Q4TSzFgNI_3hZWDkl2F3tjZfBYMX.... The formula is: =JOIN(ANCESTORS([Value 1]105), ", ") The result is: Hierarchy Formulas, Parent Row, Child Level 1 but row 91 (the 'oldest' ancestor)…
-
Automatically check-mark parent row when all children rows have been check-mark
In below scenrio, is there a formula or some approach that will enable new added rows to be automatically accounted by formulations on outdent rows? The purpose is to automatically checkmark the parent/outdent rows when all their children/indent rows have been checkmarked. Pls refer to attached picture “Query - Checkmark…
-
Automate color change on a Date-category cell
In attached scenario, is there a formula that will enable “Target Date” cell turns to red color when it is smaller/earlier than “Completion Date”? Inserting a Date category column and setting up conditional formatting gets the job done. I'm curious whether there is a simplier way. Thank you. Jon
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Formula to count/sum grandchildren
Is there a formula that can be used to count or sum the grandchildren of a parent row? For Instance: * Parent Row: United States * Child Row: East * Grandchild: Florida * Grandchild: Georgia * Child Row: West * Grandchild: California * Grandchild: Oregon * Child Row: Central * Grandchild: Illinois * Grandchild: Texas *…
-
Release 2016-08-06 Formulas template link is wrong
Regardless of how I get there, the template for formulas is wrong. https://www.smartsheet.com/solutions/smartsheet-formula-examples is version 1.5e I have 1.6 from July 2015 Craig
-
Formula using both an IF and SUM(CHILDREN()) parts
Hello people I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty. If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5) I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5)…
-
Use linked cells as part of a formula
I'm trying to port across a large database from Excel into Smartsheet to enable us to use the Kanban type activity flow. My excel sheet uses multiple tabs, and on one of these tabs I have an 'Analysis' section that pulls in data from all of these tabs and uses cell references from multiple tabs. Smartsheet (not using tabs)…
