-
Is there a way to add hours and minutes in a column?
This is the only thing holding us back form using smartsheets. Is there a way to add columns such as the one in the attached picture and come out with the correct answer for hours and minutes?
-
IF criteria on two fields
I have two IF statements that I can get to work by themselves but not together. Here is the first one by itself. The formula is in a cell called “# of Days Past Due”. Both Part A and Part B work separately. Part A - If the Date payment received is blank, it takes TODAYs date and subtracts from the Claim date, else 0.…
-
Outline level field
I'm an (expert) Excel user, using Smartsheet now in our organisation for basic tracking functionalities. It's a daily 'struggle' to understand the limitations of Smartsheet and try to keep the sheet basic and simple, but I'm quite enthousiastic about Smartsheet. On the other hand, I really miss some (in my point of view)…
-
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…
