-
Formula Help: Count number of time "Yes" occurs in a row?
Hi there! I am trying to write a formula that will count the number of times "Yes" appears across multiple columns in a single row. I am new to SmartSheet and having a hard time writing the formula. Can someone provide some guidance?
-
Use automated workflow to send an email to an external contact
Hi, I had a look through the existing questions, and couldnt find an answer to this, so apologies if it out there somewhere! we have a sheet where we log enquiries we receive as and when we receive them. In the log we capture the date the enquiry was answered, along with details of the enquiry and the response we provided.…
-
Sharing Templates
Hi, I would like to share multiple templates that I have designed so others can use within my company. Does Smartsheet have the capability to share a blank template?
-
Pie Chart Linking to Multiple Links?
Hello, I am working on a Dashboard and have created a widget with a pie chart. I have been asked to link four separate links to each of the four categories within a pie chart (attached below). I see via "Widget Behavior" I can click out to one sheet/link. Is this even possible to do? I have an idea for creating four…
-
Using COUNTIFS With Contacts, CONTAINS, and OR
I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the users of this sheet have a bad habit of entering data so that their email address displays in the contact list rather than…
-
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…
