-
How to move lines so that they are together after filtered
Hello! I created an automation so that all the rows other than rows with column X's value = Y. Now, all the lines are apart from each other because a lot of the rows have been deleted in between. Is there a command line or something in automation that brings all these rows together so that they are right below each other?…
-
Why is the Report Builder Icon not showing? Just a refresh button.
Hi, I'm new to Smartsheet. I'm trying to edit the columns in my report, but report builder is not showing. All I see is a refresh button. I've included an image below.
-
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…
