-
Rounding ONLY Up
Hello, I have a construction equipment management sheet and I am trying to create a customized rounding formula for the "months rented" cell. Equipment rentals usually charge at intervals of 1-week, after that at 2-week, then after that at 1-month. Because of this, having a value like "1.3 or 1.6 months rented" doesn't…
-
Formula for progress bar based on RYG balls
Hi, Is it possible for the progress bar to represent the amount of progress based on RYG balls. EG/ if red = 0%, yellow = 50% and green = 100% the progress bar would be an average of how many of each colour there were? Thank you
-
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,…
