-
Formula help needed
Hi guys I need help writing a formula. I'm trying to write a formula in which it calculates the fuel consumption for each truck for that specific date. What I was trying to say with the formula is that it should look at which truck, date and shift it is today, and then find the same truck and collect the odometer reading…
-
Count if by date
@Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm just counting and manually adding it to the column. Here are some screen shots This sheet is filled out at the facility: I…
-
Reporting: pulling in Parent Rows
Hello, I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However, the formula does not check parent row even when a subtask is checked. There are up to 5 heirarchy level in some instances,…
-
Cannot determine the needed formula
I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can someone help me please. Can this be accomplished with sheet summary or via a report. My brain is a bit fried.
-
Formula Using IFS, Contains, and AND
I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word "Shadow" and the Provider Last Name is the name in cell 3 (current sheet), then say "Scheduled."…
-
Using dates without a date column.
Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way to do this without the dates being in a date column as it needs to be a drop-down column. Thanks, Liam
-
How do I automate At Risk flag to change to red 72 hours prior to deadline/task end date?
Hi - I'm trying to automate the At Risk flag to change to RED 72 hours prior to the task deadline so it can trigger an email to the person assigned to the task. I have created the workflow/alert email upon red flag trigger, so that part is done, but I have not found the right formula to change the At Risk flag…
-
If(And(Or
I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equals UFN AND "max # of people.." is greater than 0 make "local ordinance status" yellow and If…
-
Using IF, AND functions together.
Hello, I am trying to create a formula whereby, if the date in the "Due Date" column is less than today and if the "Approval Completed" column box is unchecked, return 1 or 0. I need to calculate how many tasks are past the due date. Unfortunately I am getting errors in my formula, can anyone help. Thanks.
-
Sumif from multiple sheets
I need help with a formula for 2 scenarios: 1) I want to sum up the total of items from the "ATL Tasks/Notes" sheet that have any priority designation (high, medium or low). 2) Then I also want to sum up the total of items between multiple sheets "SHEET NAME Tasks/Notes" that are high priority.