-
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:…
-
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:…
-
Easiest solution I have for (time)-(time)=duration
I always look here for solutions to my ideas before I spend too much time on them. I was not able to find a simple solution for doing calculations with time. Honestly, after my initial search, I ended up exporting to excel to do the math, then importing back in. Long story short, here is a single formula to subtract start…
-
IF INDEX MATCH function has circular reference
Hello all, the following formular gives me a #circular reference mistake. Based on the below can anyone see already why this might be th case? =IF(INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)) = [CHECK Vertical]@row, "TRUE", INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0))) Let…
-
Changing a sheet formula to a sheet summary formula
I am working on a donor management tool and am looking to count the number of donors previously identified as "lapsed donors" who are no longer in lapsed status. I have created this formula within a column in SmartSheet. It correctly calculates the status of Lapsed Donor change (+1 for new lapse, 0 for no change, -1 for no…