-
About Auto Reminders
Hi Community ,I have an Invoice sheet w i manage i auto Repairs shop on wheels Receivables I have an Invoice sheet tracker I have an Invoice sheet where I have the following columns a column "service date " date type a check column type "send invoice " a check column " completed " and Description of service as a text type…
-
New approach for status on a project plan
our current project plan is driven by organization functions, the item details roll up by function. We want to move towards an outcome based plan, this would be leveraging the same plan but report the status by workstream instead of by function. Each item is tagged with the workstream. smartsheet does a great job rolling…
-
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…
