-
How to integrate two separate sheets
Hi, I have built two sheets. One sheet is the main source of data and other sheet should be updated automatically when there are changes in the main sheet. I have created an automation to copy changes from the main sheet to the other, but it's just duplicating and creating new rows
-
Formula to total together and count a status & count completion
Hard to title... But refer to the attached screenshots. On the parent task right now I have it counting the amount of child tasks' status (the progress bar). As you can see under the expanded task of "External Kick off" there are 5 other tasks. I have set them as Full on the status bar as shown and so the "External Kick…
-
Move or Copy Rows - Select a destination sheet search tool doesn't respond
I am trying to create a move rows automation but the search tool on the "select a destination sheet" window does not respond with results even after typing the entire name of the sheet I want to move the row to. I tried logging out/in, I am the owner of all sheets. The lookup also fails for the copy a row automation.
-
Automate RYG Balls based on Status and then date
Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)? Complete would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…
-
How do I use Averageif when referencing a new sheet?
=AVERAGEIF(OTP 10.21.23 SCAC Range), "CFAA", (OTP 10.21.23 dwell TIME) This is the formula
-
How do I add the Year to capture 2023 and 2024 data seperately?
Hello, This is the formula that has been working great. But with 2024 fast approaching how do I add the year. =SUMIFS({Rounding| Number of Staff Contacts}, {Rounding| CPD Educator Name}, Category@row, {Rounding |Date Rounding Occurred}, AND(IFERROR(MONTH(@cell), 0) = 1)) Thank you for any help, Lori
-
vLOOKUP SOMETIMES RETURNS NO MATCH
Hi Everyone, Thanks to some very helpful advice on here I've amended our company quotations sheet to reference a credit checking sheet and then show if a client has been credit checked and what their limit is. 99% of the time this works perfectly, from time to time however it returns #NO MATCH this is without exception for…
-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
Help with bar graph on Dashboard
Hi everyone, Hoping to get some help on a bar graph that is racking my brain a bit. I've made a sample of info i'm trying to chart: What I am hoping to do is: Have Joe and Dan on the X axis Both Joe and Dan have two separate bars, one for win, one for loss, and have total number of "wins" and "losses" on the Y Axis Have…
-
Is there a way to create a range in a formula that never changes, even if rows are inserted/deleted?
I have a sheet I'm working on that pulls data from form responses. I don't want to have to pull from another sheet if I can help it. I have a lookup like this: =IFERROR(VLOOKUP("Form1Answers", [Col]1:[Col25]5, 3, 0), "") This works fine until the form returns data and inserts the new line. When that happens, because the…