-
Google calendar like option or work around?
Hey I have 2 columns that show different dates that I would want to see together in the calendar view. Has anyone figured out a work around for this or a clever formula to make this work? Hypothetically, for example: I would like to see the Packaging Release Date, Photography Shoot Date, and Copy due date.
-
Automation Emails
Hello! I've made a sheet that's associated with a form that has automation programed. With each instance of the following, the automation is to send an email to the identified personnel New Line item (New form submission) Edits to a single field During the testing phase, both rules worked and sent out emails as planned.…
-
Workflow with Condition Path
How do I set up my workflow condition path if I have the following situation: Employee 1 (E1) should be notified of the workflow approval if his name is selected in a cell, C1. If E1 does not respond today, Employee 2 (E2) should then be notified to complete the workflow action (E1's name is still selected in C1).…
-
Why would my workflow not be sending the notification
Hello, I am using the current workflow, but for some reason it is not sending the email notifications out. I have run tests to send to myself, but still do not get the email notification. I have checked the junk mailbox, but something is not working. I have other similar workflows that seem to work ok. This is just sending…
-
Showing Contact Names instead of email addresses in Contact Column in Sheet
This discussion was created from comments split from: How to show Contact Names instead of email addresses in Contact Column in Sheet?.
-
OR( ) for multiple criterion ranges within INDEX/COLLECT/SUMIFS
Hello, any tips for using OR for multiple criterion ranges? The formula below outputs #INVALID DATA TYPE. =INDEX(COLLECT({Task Name}, {Details}, <>"", OR({X Budget}, {Y Budget}), <>""), [Expense #]@row) The goal is to only pull tasks into the new sheet that have a value for either budget type (X, Y).
-
Time Related Email Notifications
Hi fellow Smartsheet users, I have a Smartsheet setup where it will send an email notification when items are coming due. This will trigger when a value hits 30 days in a specific column. I went and opened this sheet for the first time in a while today and it sent me a notification that the item was coming due but the…
-
Sending Request an Update email to 1 person with Multiple Projects
Hello, I have a projects list (one sheet) that I need to gather more information on. I have an automation set to send a Request an Update email when certain conditions are met. Since my list is newly created, I am seeking a bulk update on multiple projects to start. My question, is there a way where only 1 email would be…
-
Multiple photo upload
We need to batch select photos in our inspection form on our phone while on site, which then needs to input into the smartsheet, one in each column because then the information from the smartsheet once generated goes to a another page which collects all the data and inputs all the information collected on one page and the…
-
Possible to Display different report based on day of week in dashboard widget
I currently use smartsheets for weekly assignments for my staff. We have a group of reports setup to show a summary of their assignments daily. What I would like to know/accomplish is whether I can format a report that handles what the 7 we currently use all in one? To give some context I am reworking our dashboard to show…
