-
Countifs with Multiple Criteria
Hi - I need assistance with building a =COUNTIFS formula with multiple criteria. Here is my current equation (that I am getting a '0' on) Current Equation: =COUNTIFS({B23 Delegation Registration Status Region}, "SOAF", {B23 Delegation Registration Status Registration G}, "Athlete" + "Unified Partner" + "Medical Staff" +…
-
How do i create a formula to source information from another sheet with multiple countifs?
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example: The metric sheet is trying to count KPI's from other sheets, for this particular instance a…
-
Basic NETDAYS Help!
Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas. I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so far every NETDAYS variation I've tried has returned the #UNPARSEABLE error. I'm trying to write a formula that will calculate…
-
Need help building your Solution? Explore the NEW Smartsheet Implementation Services Portal
Hi Community, Exciting news! Smartsheet is proud to announce the launch of our Implementation Services Portal—a one-stop shop where you can purchase select Solution Package service offerings to accelerate your Smartsheet journey. Delivered with unparalleled expertise, Solution Packages address business challenges across…
-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
-
Meeting Minute Tracking
Know how to track the previous meeting minutes without having to expand all parent and child rows so you can copy it on the next available line and enter or remove information for the next meetings. Have an option to generate a pdf that can be logged on a separate sheet for review of the meetings that you have throughout…
-
Index Match Function Help
Hi Smartsheet Gurus, I am attempt to pull information from one sheet to another given a set criterion that is present in both. I believe that either a VLOOKUP or INDEX function should suffice but cannot seem to get things to work. A little background: We would like to be able to have employees enter a form with data about…
-
If cell matches string criteria in one column, THEN return value of another column (same row)
Hello all, I have the following problem. In my first Smartsheet under the column "Revised Catalog Release" I want to output a date value if a criterion is meet. Now this is the other sheet I am referencing: In lay man words what I want is: If column "Task Name" = "Packaged Part Catalog Release" then please return the value…
-
Index Collect value based on a date
I want to index a value if the "This Sheet Date" on my final result sheet is greater than "Date Value Effective" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the "This Sheet Dates" are greater than the "Date…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
