-
Countif except N/A's
I have two columns that I'm trying to build a countif function for. First column has a value: A,B,C. Second column is checkboxes with N/A if the team member is not required to complete. End result I would like to get a final count of all the A's that are required to complete the training. =countifs(columnA:columnA, "A",…
-
Help with 6 month rolling summary metrics
I have a date column in a sheet and I am looking to count the number of dates that fall within the current, then current month +1, current month +2, so on a so forth. I think the tricky part is making sure the counts are accurate based on year as well. So since today is October 2, 2021 the rolling 6 months would be as…
-
Trailing 12 weeks/months style report
I'm looking to create sheet that will roll up data for a trailing time period. I can collect the data easily enough, but of course, the data changes over time. Is there a way to collect the data, then freeze it and collect new data in a new cell? I don't have a problem pre-building the sheet with all of the future dates,…
-
COUNTIFS CONTAINS problems
Hello, I am trying to create a formula that will count the cells across spreadsheets using COUNTIFS and CONTAINS. My formula works, however I don't believe it is accurate since I am getting a count of 0 for every scenario I try and apply. I would like to count the "Requested Delivery Quarter", shown in screenshot two. By…
-
How to rank highest to lowest
I would like to rank a range where the #1 rank is the lowest number in a range. The formula I am using ranks the highest number as #1 =RANKEQ([Revenue Per Year]1, [Revenue Per Year]:[Revenue Per Year], 1)
-
RYG Formula For Plan Vs Actual % Complete
Smartsheet Community: I tried tweaking a Similar Formula but was Unable to get the Result I desired. Here is what I am looking to Do: Red: If the Difference is More Than 10% Between: % Complete (Actual) And % Complete (Plan) Yellow: If the Difference is Less Than 10% Between: % Complete (Actual) And % Complete (Plan)…
-
Multiple Approval and levels of Escalation
I seem to be running into a brick wall. I am trying to set up an approval process that can have multiple tiers. I have a worksheet that assigns someone based on the territory. All the while I am needing to track on the worksheet where the approval is currently... Territory: CA, WA, AZ = Bill Jones, ID, NV OR = Bob Smith;…
-
I need to make this formula more compact/ fit into a cell. Any Ideas??
=COUNTIFS({[Orange] Service Support KPI - [2022: Q2] Range 1}, [ABC Name:]@row, {[Orange] Service Support KPI - [2022: Q2] Range 3}, @cell = "NEWS - Pull/Send", {[Orange] Service Support KPI - [2022: Q2] Range 4}, AND(@cell >= TODAY(-8), @cell <= TODAY())) + COUNTIFS({[Orange] Service Support KPI - [2022: Q1] Range 1},…
-
Calculation from Smartsheet forms via different smartsheet
Hi, Thank you in advance for your help, I am trying to do a calclation from a smartsheet forms that i am sending to my team and they are answering few questions. Based on their answers, I am trying to gives values to these answers by using automatisation cross sheets using IF formulas. I have 3 smart sheets : Smartsheet…
-
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…