-
Nested IF error
Can someone tell me where to place the last [value false] information on this very long formula? I'm having issues with it always showing the last true value (20) for the false values (School Missing) or an error message when I move it to a different spot on the ending parends: =IF([Grading Scale]@row = "50", 2,โฆ
-
Set Up a Time Frame formula by which a task needs to be completed
Hi everybody, I am trying to create a formula that triggers an orange light or a red light after a certain amount of days has gone by since the creation of the issue. E.g. an issue is created on January 1. I have 7 days to solve the issue. The formula would trigger a green light up to 5 days left (for instance, past theโฆ
-
Cumulative count formula
Hello, I hope somebody can assist me. I want to develop a production tracking sheet based on the simplified test sheet as per attached snip. The data is generated by a batch counter on equipment and at the end of the shift the production staff enter the daily total into the green cells and the sheet then calculates theโฆ
-
Formula from 2021 and 2022
Hello, Can you help me with the formula? I need to count the "Pending" from August 2021 onwards to 2022. =COUNTIFS({2022 Orders - Carmi Range 1}, "Pending", {2022 Orders - Carmi Range 2}, AND(IFERROR(MONTH(@cell), 0) >= 1, IFERROR(YEAR(@cell), 0) = 2022))
-
Set the Start Date and End Date Based On When A Task Was assigned
I want to set the start date for a task when someone is assigned to the task using "Record A Date" in a workflow. I also want to assign the due date 30 days from the start date. I know how to use the "Record A Date" workflow and I know how to add 30 days to a date. So please don't explain them to me. The problem I amโฆ
-
How to automatically check a checkbox ?
Hi ! I'm looking for the formula to automatically check a checkbox (Column named Urgent) when the due date has passed (Column name Deadline). The column Urgent is a checkbox column and the column Deadline is a date column. I would like that, when the date in the Deadline is passed, I want the Urgent box to be tickedโฆ
-
Sum Children
Hi How do I add together all cells in children rows using a formula? Thanks!
-
How to automatically copy a cell value to the next column
Hi =), It is likely a very easy solution for you guys. I've two columns one for the client names (Dropdown list) and another one for OTHER ( if they can't find the client name from the dropdown). I wanted to bring the OTHER client name automatically to the client name once someone enters data in the OTHER column. Goal isโฆ
-
Trying to match values from different sheets
So I have the master sheet that has a Machine Name column, and I'd like to match it to a Department that is inputted in a separate sheet. Sheet 1 has 2 columns, Machine Name and Department (this is where the formula will go). Machine name is constantly added with random names being chosen out of a drop down selection fromโฆ
-
Unparseable error
I created a formula, for tracking time, and as the owner, it works really well. But when I share the sheet, no-one else is able to use this. The error message comes back asย unparseable. This is the code. fx=SUM(((TIME([Time Out]20, 0, 2) - TIME([Time In]20, 0, 2)) - [Non Billable Breaks/Mtgs.. ETC]20) * 24). thoughts?