-
How to set up a departmental time off request sheet?
I was wondering how I could set up a document that is one sheet for time off. The main things we need are a form or something to fill out that will go to the employees specific manager to approve or deny, and will then notify the employee if it has been denied or approved, and if approved, will then populate in the sheet…
-
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
