-
Submitter (Created By) Showing as Web-Form
Hi -- we have a sheet we are using by sending the link to the form to all employees. They manually enter their email address in the form. The issue is when the form is submitted the workflow automation doesn't work because created by is a web-form. The email from the email address column that was entered by the employee is…
-
Reports-Calendar View- Tasks from various sheets intermingled, how to fix?
Hello, I created a report to pull various training calendars into a master report. I have New Hire classes vs Cross Training classes color coded from Conditional Formatting. When I look at the Calendar View of the Report, notice how some of the blue colored tasks are falling under the green colored tasks. How can I keep…
-
How do I get a hold of customer service?
I opened a case 10 days ago and have not been contacted nor has my issue been resolved.
-
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…
