-
Multiple Time Based Alert Workflows
Hello, I have two alert workflows: 1) Send an alert to contacts in a cell on M/W/F at 11:00a.m. 2) Send an alert to contacts in a cell on T/Th at 5:00p.m. My question is: In this scenario, does the workflow only look at the day it is scheduled to run? i.e., Workflow runs at 11:00a.m. on Monday, looking at all changes made…
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
How do I email a central database of contacts?
Hi Everyone, I have two separate sheets. Sheet 1 is a database of all my different suppliers, which has their name, email, and specific item which they supply. Sheet 2 is where I specify what item I would like to procure at a certain time. Once I specify the item I want to procure in sheet 2, How do I automate an email to…
-
Duplicate Automation Email
Hi all. I am trying to notify a coworker when a customer has multiple entries on our sheet. I currently have it set up so they are notified, but it only includes the new line that was added showing it was flagged as a duplicate. Is there a way to have the email show both rows in the email notification?
-
Upload Data Shuttle Flow Deleting Rows in Target sheet
Hello Smartsheet group, I am facing the same issue trying to test an upload workflow. I have created an upload workflow that will pull from OneDrive - XLSX file and replace the rows of information into my target Smartsheet file. For some reason the target Smartsheet file is only deleting the rows of data and not uploading…
-
Outlook Update Request Date Format
My business uses Smartsheet in UK, and on all our sheets the date have been set to appear in European format i.e. DD/MM/YY. However, on update request these dates appear in American format in the mail i.e. MM/DD/YY. I contacted Smartsheet on the issue and there is no way to change the format in the mails at the moment.…
-
Allow Approvals and Update Requests to be completed by individuals not shared on SS
Hi SS Community. Smartsheet automations are great for collecting information from others! One problem I have been experiencing is wanting certain individuals to approve/decline requests. As it is, you are only able to approve/decline if you are added to the sheet. I work within a company with 20,000+ employees, my…
-
Broken Workflows in Project Toolkit - Expected Behavior?
I am working on editing a project toolkit (similar to Smartsheet's PMO template set) and several workflows are set to "send to specific people". When my colleague tries to save the entire toolkit folder as new all of the workflows that are set to send to specific people break. The workflows are still there, but there are…
-
Ownership of sheets and workapps
I have been working for sometime on a collection of sheets, datashuttle workflows and a bunch of other things and have recently published them via a workapp, how do I make sure that ownership of these objects is not just limited to me to make sure that it doesnt "die" if my account gets limited, removed or otherwise…
-
Progression chart
Hi everyone, I have a questionnaire solution that only reports the latest attempt to answer it. It records how we as an organisation are doing against ICO Guidelines. My manager has asked me to create a dashboard that shows progress. So a line chart that will show how the organisation is progressing. My problem is the…