-
Prevent Check Box formula from erasing when check-box is manually checked by accident.
In below scenario, check box formula disappears when the cell is checked manually by accident. Is there a way to prevent check-box-formula from being erased when the check box is manually checked? • Pls refer to attached picture “Query - Check Box Formula” for check box formula used. Thank you. Jon
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Referring to comments/discussion in cell
Hi All I'm looking for a way how to insert text comments into cell. Is it possible (in read-only mode)? Use case: we have a sheet for issue tracking purposes which consist of the following columns: issue id, issue title, issue description, current state, status, etc. At present we use the “current state” column as a log by…
-
Display a date on parent row only when all children rows contain date
How may we fix the below formula for parent row so that it displays the most-future-date from children row after all children rows are filled with dates? =IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), MAX(CHILDREN()), 0) Currently, "0" (nothing) is displayed on parent row no matter whether there is/are dates in children…
-
Using formula =MAX(children())
Dears: I'm talking about one Date formated column. When my Parent cell has that formula and I have 4 children's (2 filled and 2 unfilled) the formula returns the MAX value between the 2 filled cells. I want for my Parent the MAX from all four childrens. I need to return the MAX value only when the 4 childrens are filled.…
-
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.
