-
Link an entire column from one sheet to another
Hey guys, I have 2 sheets, one is VS EE (the source sheet) and the other is VS BD (the destination sheet) I'm trying to link a col "Epic" from VS EE to col "Epic" in VS BD. Linking won't work for me because I need the new rows also to be linked. Another thing is that I don't have any cols to match. I just need that col…
-
I want to avoid an error message on a SUMIFS function.
Here is the function: =SUMIFS(Amount:Amount, Date:Date, YEAR(@cell) = Year@row, Date:Date, MONTH(@cell) = CurrentMonth@row) This works to tell me the "Amount" of a specific month and year. The problem is I get an #INVALID DATA TYPE message if the cell in the Date column is not populated but the cell in the Amount column…
-
How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?
I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field. I would like it remain blank until an End Date value is entered. =IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.…
-
date formula - how to add a time frame in the formula (2021 vs 2022)
Hi I am trying to add one more piece to my simple formula. I need to count the Released items in report for 2021, and for 2022 separately. So that we can see if the work done last year is smalle or bigger to what was done this year. So I am trying to add a date condition, preferably one that would be easily modified after…
-
What is WORKDAY formula with SLA built in
Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays). Thank you so much
-
Need help with this formula
Hello, Can someone recommend a formula to provide an average based on a name on the row. Example, I will have 4 rows for each person but want to average the scores for that person. Image below: Thank you for your help. Rebecca
-
Sum values on another sheet based on two columns
Hello, I am attempting to execute the following formula: =SUMIFS({Transfer Amount}, {Transfer Type}, "Recognized", {Month Invoiced}, >=DATE(2022, 1, 1), {Month Invoiced}, <DATE(2022, 2, 1)) where I want to sum values in a column based on a 2nd column's criteria and a 3rd date column range. The formula worked in test sheet…
-
Formula for Expiry Date + 36 months
Not real savvy with formulas so apologize in advance if this is pretty basic. I need a formula to calculate an expiration date based on an "Award Date" + 36 months. I don't currently have a "helper" column to designate 36 months but can add if needed. Also, Award Date and Expiry dates are set as a date column. Thanks for…
-
Formula help
im trying to create a formula that when a date is entered then an amount from another cell is populated basically when task is completed based upon a date entered then this is the revenue
-
Task Tracking: Scheduled against actual completion date with IF/AND/IFBLANK and TODAY functions
Hello, I am trying to set up colour codes to track actual completion status against scheduled completion. Blank: Not due yet Blue: Due today or tomorrow Green: Completed, On time Red: Overdue, Not completed Yellow: Completed, Late I found a formula on this forum (Thank you!) and tweaked it just a little to fit my needs. It…
