-
Countif Formula with Criteria
I am counting "On-Time" in another sheet and want to add additional criteria. So countif column Proof Delivery Status is "On-time" and column Alterations is NOT checked. Current formula =COUNTIFS({Premedia Completed Proof Delivery Status}, "On-time") Shouldn't this formula work =COUNTIFS({Premedia Completed Proof Delivery…
-
Countifs check box is blank between dates
=COUNTIFS({MASTER - Daily Report - Employee}, [Employee Name]@row, {MASTER - Daily Report - PM Checkbox}, 0, 1, {MASTER - Daily Report - Date} >= [Start Date]@row, {MASTER - Daily Report - Date} <= [End Date]@row)
-
Census Information for a company
Is there a way to add and delete employee info with an automation and formula. I need to get accurate count of how many people are in the company and what tier they fall into. I would like to have an up-to-date sheet. Updated Census Sheet
-
Sheet Summary NETDAYS referencing another sheet summary formula
Hi, I cannot quite find a solution I require for this question in the community. Hopefully someone with more knowledge can help. I have H&S sheet logging any incidents, accidents, near misses etc. I am trying to build good sheet summary data to pull metrics through to a dashboard. I have already completed Date of Last "X"…
-
Sumifs bewtween dates
=SUMIFS({MASTER - Daily Report - Reg Hrs}, {MASTER - Daily Report - Employee}, [Employee Name]@row, {MASTER - Daily Report - Date} > [Start Date]@row, {MASTER - Daily Report - Date} < [End Date]@row) Whats wong with th? Im getting #Invalid Operation
-
Recording dates in single workflow
Hello Everyone, I hope you are doing great I am trying to record 4 different dates in a single workflow but getting dates in only in the 1st date column and all the 3 date columns are not working. In my sheet I have 4 different status columns and their value is (Not Started, In Progress and Complete) Status 1 - Not…
-
Traffic Light System for Due Dates
Hi, I was wondering if someone could help me with a formula. I'm looking to do a traffic light column for the following rules. Hopefully I've made this clear, if not any suggestions would be appreciated. Our products (Panels) take 7 days to arrive from manufacture. If ( [10] Panel Despatch ) + 7 days is EARLIER than the…
-
Sheet /Column sharing
I have 5 sheets. The first 8 columns on each of the sheets are the same. The balance of the columns of each sheet are different. Is there a way to have the first 8 column interactive regardless of which sheet you are in. So whether you make a change in sheet 1 or 3 (within those 8 column) all 5 sheets in that cell are…
-
Formula with Dates
I am trying to reference another sheet where that column will be marked "completed" and then using the star symbol, have it toggled on if the date is in the month of January. Any help is appreciated! I'm new at this :) =IF({RANGE 1}, "Completed", IF(AND({RANGE 2}, <=DATE(2022, 1, 31), {RANGE 2}, >=DATE(2022, 1, 1), 1, 0)))
-
Feature Request
Hi All, Just hoping maybe this would be half decent feature request to see if anyone else has run into this issue. We use the 'Request a response' feature to email our clients to return specific information and it be automatically allocated to that row. Although unlike the forms feature we cannot set specific response…