-
Autogenerate report every day without duplicates
I'd like to generate a report that updates every day with the tasks due in the next 7 days. Then, once that task is completed, it comes off the report. I've figure out how to get it off the report; just having an issue with the first part. I created an automation in the project plan to copy rows at a certain time every day…
-
All cross sheet references randomly removed from sheet
Hey all, I have a weird issue. I have a sheet we use for our install calendar and randomly all the cross sheet references will be removed. This has only happened one time in November and again this Wednesday. I spoke with support and they said it might have to do with the automations but I'm not sure why the automations…
-
Dynamic View Comment Emails
We use Dynamic View for our sales force and customer service reps. They each have their own respective view that is connected back to the main sheet. Our design department uses the main sheet to process incoming requests via a form. We have run into an issue with links in automated emails using the…
-
Desktop App
We have different automations set to trigger email notifications and I was wondering if there's a way for the link in the email to open in the Desktop App. Right now, when I click on the link on the SS generated email, it opens up in a browser instead of the desktop app. Any idea if this is possible? Thanks!
-
Automated form
Is there a way for a particular cell in a preexisting row to get updated via a form or similar? IE a row already exists. A date is entered into column A which causes a form to go out to the contact in Column B and this form contains columns C, D, and E which contains drop down menus and star-rating columns that the form…
-
Allow form user to include commentary on approval workflow/automation
Hi all, I'm creating an intake system for site related issues and want to allow the person assigned to the ticket to request approval of resolution before closing the issue. Ideally, the assigned owner would put a status of "Resolved - pending approval" that will trigger an automation to run an approval workflow. I need…
-
Automations and Cell Linking
Hello, I've read in a few past threads that automations will not work with Cell Linking. For example, I have a column that uses VLOOKUP to pull a Status from another sheet that is imported via Data Shuttle on a daily basis. I wanted to have the rows moved to my completed sheet anytime the Status changes to Closed. It would…
-
Run an automation based off a primary automation?
I have been tasked to create an automation for alerting someone about entering in Smartsheet details the day after the primary automation sends them an initial request to input their information. My question is, is this even possible? I've been doing some experimentation and it does not seem that I am able to create an…
-
Columns appearing when a row is copied and moved by automation
My underlying primary sheet is populated by a form, I have a further automation set up which copies and moves the row to a new sheet if specific criteria are met, in this case "Yes" is selected from a drop down menu (this is in columns that are beyond the form populated fields). When the row appears in the new sheet, 5…
-
Excluding link to sheet in Alert Someone workflow
I know this is a commonly asked question and I have already submitted a feature request, but I am curious to see if anyone has developed a workaround for excluding the link to a sheet in Alert Someone workflow. Scenario: I have a sheet containing confidential information that users submit requests to via a form. The sheet…
