-
Formula adjustment to calculate date based on years duration
Hello, I currently use the below formula to automatically give me a date if I enter the duration. Now, this currently only works if I enter it in months. Can someone help me adjust this so that it calculates based on years duration? =IFERROR(DATE(YEAR([Start Date]@row) + ROUNDDOWN((MONTH([Start Date]@row) + [Duration…
-
#invalid Datatype Error
Hi all, I've a formula to calculate estimated hours. =SUMIFS({Master Summary - Estimated Hours}, {Master Summary Rollup | Live Date}, YEAR(@cell) = [Year Helper]@row, {Master Summary Rollup | Live Date}, MONTH(@cell) = [Month Helper]@row) The formula uses two references to a Master Summary sheet. Estimated Hours (from…
-
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,…
-
Sum Of Children (but don't add any negative value fields)
All, I'm going nuts. I can't seem to figure out a simple formula that is essentially "sum of children, but don't factor in any children with negative values". Can someone please help? Many thanks, Evan
-
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…
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are…
-
COUNTIFS for whole Sheet
Hey, This is probably an easy fix but I am having no luck. I want to count if anywhere on a sheet has a "4" in a cell. I also want this to separate the counts by "ITCMW", "ITCT" & "METC" My current formula is: =COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4")) I need to include System:System, "ITCMW" in this…
-
Monthly Automation report sends out last months data
I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, every month I receive the email on the first of the month and it shows the PRIOR month anniversaries. Within the sheet I am…
-
Formula - Cross Sheet Referencing
Hi Community, I’m trying to cross-sheet reference. After I type the start of the formula, the box to “Reference Another Sheet” appears. I clicked it, found my sheet, chose the column, but the “Insert Reference” box remains grey. I’m the owner of both sheets. What am I missing? Screenshots attached. Thank you!