-
I can not figure out what is wrong with my CountIFs formula
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$") It works great. However, I…
-
Generating previous quarter from current date
Hi there, I am trying to get a formula that will generate what the previous quarter is for our fiscal year which starts in October. So for today April 2024 which is in our Q3, the previous Quarter would be FY24 Q2. If we were in October 2023, the previous Quarter would be FY23 Q4. If we were in January 2024, the previous…
-
Countifs Question
Greetings! How do I use the countifs formula to count if area =1, category 1 = x, and Date range is April? For the example below the value generated by the formula should be 1. How would I do the same but date range is all of April up to "today"?
-
Standard Deviation uptick/downtick
I know standard deviation is calculated between 0 to infinity, however, I'm wondering if anybody has a method for inverting the standard deviation to negative if the deviation goes from bigger number to smaller number. In this case, 4/17/24 deviation would be -707%, as compared to 707% I am using STDEVS(COLLECT() based on…
-
Index Match returning incorrect information
I have a smartsheet with trade numbers and I want to pull in the invoice number, invoice due date and invoice amount for the invoices tied to a specific trade number. I had it working correctly but then lost the formulas when I ran out of rows carrying the formula and now I can't get it to work right. Each week I get a new…
-
#Divide by Zero Error
Hello, It's been awhile since i wrote a big formula. I just need some guidance on getting my formula to return to 0 if there is no data to populate a value. As you can see i have some other IFERROR logic in my formula but for the overall sum I cannot for the life of me figure this one out. =SUMIFS({1st Reply Duration},…
-
Formula Needed!
Hi! I am needing a formula that will count the number of occurrences month to date of a specific data point. I am working on a dashboard for complaints and I am wanting to have a formula on my master sheet that will calculate the number of regulatory complaints we have received month to date that will update with new…
-
Is there a way to reference the value in a cell as a numerical value that functions in a formula
Hi Community, I have a 13 week rolling chart. To gather, I have groups like this one below for each of the thirteen weeks. this one shows 10. Is there a way to change the value for the weeks ago portion (in red boxes below) to be a value in another cell? In other words, I could reference the 10 in the red box on the far…
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
traffic data in 6-hr intervals over a 12-week period
Hi All, I want to show data in 6-hour intervals over 12 weeks (Feb 2024 till April 2024). How do I create a dashboard for it? Columns include: Only if I can know the total number of tickets received for the past 12 weeks in 6 hour timely interval for the past 12 weeks Any help would be highly appreciated.