-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
-
Imported sheet formulas not all working
I imported my sales tracking sheet and most of the formulas are working but some of them are not. this is what they say: #UNPARSEABLE#BLOCKED#BLOCKED Here is a screenshot of what I have in some cells. https://screencast.com/t/J1Rvx4iz0 I don't know how to fix this.
-
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…
