-
Usage of [ ] symbols and ( ) in formulas.
Hello Smartsheet community: In the attached picture, why "Task Name" variable needs to be surrounded by [ ] symbols while "Cost" variable does not? Thank you. Jon
-
Nested IF formula using additional AND/OR logical functions
Hello everybody, I am struggling with creation of formula for defining Invoice Status Symbol (RYG). Geeting the UNPEARSEABLE error message. My formula is right now as follows: =IF(TODAY-[INVOICE DUE DATE]11>30,"Red",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),"Yellow", IF(OR(TODAY-[INVOICE DUE…
-
Color parent row while any children rows becomes red
How may we construct a formula so that a parent row will be highlighted in red, if any of its children row becomes highlighted in red color? Thank you. Jon
-
Countif with wildcard
Need some ideas how to count number of cells in a range with any text in them. The formula below returns 0 (when all cells in the range contain text) =COUNTIF(Column Name]10:[Column Name]19, "*") Any ideas for text wildcard? Thanks
-
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
-
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…
