-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
Copy Row Automation
I am trying to copy rows over to another sheet once a date is reached and the respective review period has begun. The automation workflow I have is this: Trigger - When a date is reached Everyday at 6:00 am Condition - Where deadline is today Copy Rows I am not having any luck with the rows copying over to the other sheet…
-
New to Smartsheet - Setting alerts once status has changed
Hi all, I hope you are all doing well. I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartsheet. Currently, I have a project on hold sheet which records all projects that are…
-
Automated Reminders Based on Approaching Due Date
Hello Community, I am attempting to produce an "if/then" statement within a column of my project management smartsheet in order to create an email automation to remind the assigned user to address the aging task. Using the formula, I should be able to create conditional formatting or email automation workflows that address…
-
Automation
Could you help me ? do you think i did it right? I want to automatically send a reminder mail to the responsible persons on the 60th and 15th days. the trigger should work every day and; it only needs to work on the 60th and 15th days of the contract date. example1: 60 days left until the end of the contract. example2: 15…
-
Approval workflow
Hello! I need to create an approval workflow with these conditions. Please also find below the problems I'm encountering: When a row is added, changed, or deleted. (Problem #1: I don't manage to set this up for rows that have been deleted.) When any action above is performed only by specific email addresses. (Problem #2:…
-
Form Data
Hello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help. 1) I need to create a form that will be filled by users to sign-up for different games. On the form my first drop down is Venue and that's the easy part, however when they select the…
-
Dashboard Reporting Logical Filtering
Hello, I am currently devolping an Automated Dashboard Template that may function as a Site Visit Report. The project consists of developing thousands of Site Visits Reports, hence the need for an automated system and data entry. I developed a Grid and Form that will be a user-friendly tool during each site visit. However,…
-
Using Calendar App and JIRA Connector to build a Release Calendar
I am using the Calendar App to create a release calendar that tracks all our releases along with their respective critical path milestones. I would like to dynamically include the Jira Epics and stories that correspond to each release using the SS Jira Connector. These stories will thereby represent the planned release…
-
Can I create a "No-Reply" user within Smartsheet to send external forms?
I am creating several forms and automated email alerts that will go to external resources and I do not want my name attached. Could I possibly create a "No-Reply" user in Smartsheet and transfer the sheets to this user? I understand the "No-Reply" user would require a license which is not a problem.
