-
Summary Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row. I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way…
-
Formula IF Due date help!
Hi, I'm trying to do the below: - When a date range - TODAY () is less than 30 it shows 'Current,' - When a date range - TODAY () is less than 60 it shows '30' - When a date range - TODAY () is less than 90 it shows '60' - When a date range - TODAY () is less than 90 it shows '90' I can get it to say current, and it works…
-
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…
