-
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…
-
How to count cells with BLANK value in a column
Say that I want to count how many cells with BLANK in a column? The column have many NOT BLANK values also. eg. ([Col]2 with BLANK value) Col row_1 a row_2 row_3 a .... row_n a so the column has 1 cell with BLANK, the count will be 1. How to write a formula to get the count? Thanks!
-
Count if & Unique Values?
Hi! I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates. Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10…
-
How to SUMIF in Smartsheet with multiple criteria requirements from one column
I am having difficulty transferring the formula below from Excel over to Smartsheet. Below is the current formula I need from Excel. I need Smartsheet to produce the same result. I'm new to Smartsheet and have gone through the self-help videos, directions, and pop-ups to see if I can get the formula below to work in…
-
I am trying to get a weeks to go formula to return "0" if negative.
I have a formula =(Date@row - TODAY()/7) to return the weeks to go for a date column. I want to make this formula to prevent it from showing negatives when weeks to go are in the past. I've tried: =IF(Date@row - TODAY()/7 <0, Date@row - TODAY()/7, 0) and it comes unparsable. I am thinking my dividing by 7 may be the issue?…
