-
Subtotal Formula
Hi, I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field. I tried to apply the same forumula but not working on smartsheet. Is there a way to calculate subtoal of the filtered rows? Please guide.
-
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…