-
Overall Project Status based on frequency?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Using INDEX MATCH Function with a Multi-Select drop-down column
Hello, I am trying to use an INDEX MATCH function to fill in the Transmission Region for the Sites Under Consideration, but am running into a problem when there is more than one site selected. I believe I need to add the HAS function, but have tried several ways and can't seem to make it work. Any help is appreciated!
-
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…
