-
Creating an automated report
Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is check, that that task is added to the report and displayed on a dashboard. Is this…
-
INDEX MATCH MULTIPLE CRITERIA
I need an index match formula that can return a match when multiple criteria are met. such as All A's & B's in sheet 2 and indicating a MATCH in sheet 1
-
Is there a way to 'automate' the filling of a DATE column via a formula?
Hi Community, My scenario: I am using a MIN/COLLECT formula to pull the earliest date from a list after a set criterion is met. I now want to have the same field 'lock-in' the date when another criterion is met, column x = "Scheduled". I am unsure if this is possible without creating a circular dependency. I did think to…
-
Health column formula to automatically change based on due date
Hi all, Looking to get some help / formulas to help me with my sheet. I would like my health column to change colours automatically based on: Green = Status column marked completed Yellow = due date two days away from today Red = Due date in the past
-
Sheet Summary - Formula
Hi! Trying to create my sheet summary. I have one column, Orders Keyed, and a second column, # of errors. I have created a summary for each total. Now I need to get a percentage out of those. i.e. 18 errors out of 4308 is 0.42%. What is the right formula to do this?
-
Countifs / Contains
Hello all, I had this formula working, I'm not sure what I changed to make it stop working. I've looked at it and played with it to get it working again and it won't. Please someone show me what I'm doing wrong. =COUNTIFS([Due this Week]:[Due this Week], 1, Status:Status, CONTAINS("In Progress", @cell)) I just want to…
-
Compare Master JobCodes sheet against NEW employees sheet on third sheet
HI there I'm trying to determine if a jobcode on one sheet is NOT found on the Master jobcode sheet and populate them on a 3rd sheet *note if a 3rd sheet is not possible, I could settle for placing the formula on the Master jobcode sheet NEW EMPLOYEES SHEET - imported from excel into SS MASTER JOBCODE SHEET - should…
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
Percentage change between two columns
Hello. I am trying to create a formula that will give me the increase or decrease between tickets in a quarter. I have the formula to count quarterly. I just need something to give me the variance between tickets during a quarter. Q1 = 130 Q2 = 340 QoQ% = ?
-
Formula Assistance
I'm struggling to pull a particular formula from my data source sheet into my metrics sheet. My criteria is to Count If: Submission Request is "Manager Change (Talent Only) Talent columns #1-10 are not blank Submitted Date is between August 1 and August 31 I've tried several things. The last effort being the below formula:…