-
Comparing dates and returning a RYG ball
Can someone tell me what is wrong with this formula: = IF(TODAY() - ["DUE"2] > 0, "Red", IF(TODAY() - ["Due"2] > -3, "Yellow", "Green")) I am trying to compare today to a due date and return the appropriate ball. Thank you.
-
Bug: Auto-Save has unexpected results
Please see my comment and description of the bug here: https://community.smartsheet.com/discussion/summary-report-multiple-sheets-modified-date?page=1#comment-19340 When auto-save after 3 minutes is on, a sheet with the TODAY() formula in use will auto-save on initial open after a few seconds. While this may be a…
-
COUNTIF problems with data types
( I have looked extensively to see what issue I'm having but cannot find an adequate answer ) =COUNTIF(StartDate:StartDate, MONTH(@cell) = 2) Task: Just count the rows where a Date Field is FEB ( we'll use StartDate as the field and it is a DATE field ) ----- The result I get is #INVALID DATA TYPE Why is SS indicating a…
-
Formula enhancements: Usability study sign-up
Update: The Formulas Usability test is now complete. If you are interested to have early access to Formulas enhancements and other features, we invite you to sign up for the Early Adopter Program. Here's an information sheet about the program, and here's the sign up form. Best regards, Daniel ------------- Hi all, We're…
-
SUMIFS - Multiple criteria syntax guidance
Hello, I am am struggling to get SUMIFS working with multiple criteria values. I want to sum data based on Month column and then by probability column. Here are a couple methods I have tried but I cannot seem to figure out what I need to do in order to make it work. =SUMIFS(Month:Month, "March", Probability:Probability,…
-
If cell is not blank, checkbox
Hi, I would like a formula in column1 that says, if column2 is not blank (meaning it has ANY text in it), check the box in column1. Any ideas? thanks!
-
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…
-
LOOKUP documentation mismatch
The formula documentation: http://help.smartsheet.com/articles/775363-using-formulas gives these as the arguments: LOOKUP(value, collection, return_column_index, collection_match) while the Template for Formula examples gives these arguments: LOOKUP(lookup_value, lookup_range, return_column_index, range_lookup) The fourth…
-
Feedback Requested: Using Formulas Article
Hello Community! We just made changes to the "Using Formulas" article in our Help Center that we’d like your input on. A few of the modifications include: * Alphabetizing the list of available functions. * Extensive function argument definitions. * Up-to-date list of error messages. We hope you’ll find that this makes the…
-
Parent Date Roll Up
I currently have a sheet where i have multiple columns with dates thats that are going to need to roll up to the project level parent. I am looking for a way to roll the dates without using the predcessor function as it doesnt quite work right. In the picture below you can see some of the columns. I would like to have the…