-
Can the IF() formula use a conditional test from a different sheet?
..or does the test have to be within the same sheet?
-
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect status…
-
Calculate a whole number with a remainder
Hey All, I have a column that calculates the time a vehicle is in our fleet. It returns a whole number such as 500 days. Is there a formula that will convert that to number of years with a remainder being the number of days. (1 year 135 days). Any help is much appreciated. Thanks Dwayne
-
Feature Request: JOIN argument range
Slightly related to: https://community.smartsheet.com/discussion/release-2016-08-06-formula-argument-declaration-confusion JOIN appears to be "vertically-centric", that is, designed more for joining text from a vertical range instead of a horizontal one. I would like to cherry pick cells from the current row to JOIN into a…
-
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.…
