-
Formula to Count multiple text values in a range
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
-
COUNTIFS Using both AND and OR
Hi, Looking for a bit of help trying to utilize the COUNTIFs function to filter based on a specific value for one variable and between two other values for the other variable. In the sample table below, I'm looking to get a count where the TASTE is PREFERRED and the ALLERGIES is either YES or UNKNOWN. I've tried the below…
-
HELP with formula - Countifs which counts total with 3 criteria met
I can get two criteria to work with the first part of this formula but when I add the third condition I get an error. =COUNTIFS({Return Mail Deep Dive Can Remail}, "Yes", ({Return Mail Deep Nixie Reason}, HAS(@cell, [Primary Column]@row), ({Return Mail Deep Dive Grouped Findings}, HAS(@cell, [Grouped Findings]@row)))) Can…
-
Is there a way to have each row calculate the duration?
Hello! I am trying to make a travel for work log where when someone enters their dates they are traveling for work, it automatically calculates it in the travel for work days column. I like how the below screen capture is set up, I would just like to find a way to automate it without having to enter in how many days they…
-
Index/Match Help
Hi - I have a sheet called "Source Data" which has a list of roles in Column A and the description of the Role in Column B. In another sheet "Worksuite Requests" I want the description from the Source Data to pull in if the role name is a match. I can't quite get the formula:
-
VLOOKUP issue
I am trying to pull totals from my 2023 sheet into my 2024 sheet. The totals I am pulling are in a different column but same row as where I want them, so I decided to use VLOOKUP. 2023 Sheet: 2024 Sheet: I want 'Total 2023' to be pulled and placed in 'Previous Years Total' for each corresponding row. My formula:…
-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but it works well and requires little to no maintenance. I still find some very small use cases where this comes in handy.…
-
How to count different text values listed in a column
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
-
Year-to-year best practices when it comes to metrics based on dates?
Greetings- I need some advice in regards to best practices when it comes to tracking multiple years and what to do when one year ends. For example, my SS below tracks submissions via the form by month and year using the formula below for January. =COUNTIFS({Community Engagement Request Range 1}, "1", {Community Engagement…
-
Formula Help - Childre
I recognize that this is probably very easy and there are several topics on this already in the Smartsheet community. I swear I have searched them all and the suggested solutions are just not working for me. Any guidance is appreciated. I've created a very generic task list, that includes columns for Start Date and End…