-
Sum Children() If Date <=today()
I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today(). Any thoughts?
-
Nesting COUNTIF/AND Formula
I am trying to create a formula that returns the count of items past due, 0-30 days, 31-60 days, and greater than 61 days. The formulas I'm using is (respectively): =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of Days Past Due]2:[# of Days Past Due]18, <31 >= 0)) =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of…
-
Can I use cell history to calculate how much time has taken between two non-date cell types?
Hello SS Community, I have a sheet that is used by medical professionals. We need to calulate the time between a cell that is filled out when a patient arrives, and one that is filled out when they leave. The cells are text based and not date type, nor are they cells where the user is typing in a time (so I cant simply…
-
Counting the number of check boxes
Hi Please, can some help I have a sheet that uses check boxes and trying to count the number of boxes in that have been ticked. I am using this formula however it just returns a value of count 0 Any Ideas ="Count: " + COUNTIF(CHILDREN(Sent47:Sent1), 1)
-
Bill Payment Function Needed
I am looking to to create a spreadsheet that has the following functionality: - Bill Date Column updates based on the frequency (monthly, quarterly, yearly) every time the check mark is checked. Example: Verizon / $100 / 3/1/2017 / Monthly / Paid (Check or Uncheck)
-
Starting time with predecessors
Is there a way instead of using a starting date, I can use a starting time? I have tasks to plan during the day for maintenance, this usually doesn't take more than a day. I want to use gantt view as well. I know the hour function has been added recently as I understand, so why can't I add up the hours starting from a…
-
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
