-
Is there a better way to send notification if a cell has no update?
I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this workflow I created the following helper columns: Modified: auto number with date formula Modified date: date only from the…
-
Weekly Workflow Notifications Across Several Sheets
I am pretty certain I know the answer to this question, but want to check with the community! I have a portfolio of sheets that all follow the same structure, but they are segregated by specific client. If I have workflow on each one to send a weekly notification update based on specific criteria. Will I receive a separate…
-
Repeated reminders for no response to update request
Hello, is there a way to set up notification for reminding the update owners to complete their updates until they are done? For example, the due date is 12/10 and the update owner hasn't updated the status. I would like to send them daily reminders until they have changed the due date and/or update the status.
-
Workflow: Request Update Form
Hello, For the automated workflow - request update option, if I have this sent out to more than one person to complete and they both leverage the linked form from the automated Smartsheet email, how does Smartsheet intake that information? Would it create two entries or combine into one? This would be for a weekly status…
-
Email Changes to Name
When I enter in my email address, it changes to a name format. I am trying to Index/Match it to another sheet and it doesn't recognize it unless it stays in the email format. How can I set up to not convert?
-
Include Multiple Recipients on Single Email Alert
We are currently using a form to track internal requests. We are trying to get smartsheet to send an email to multiple recipients on a single email thread. Essentially using this form to generate an email thread which has all of the following recipients: the form submitter (dynamic) and all individuals within our solutions…
-
Best way to implement a notification upon sheet creation
Hi Smartsheet community, We have a number of pre-formated sheet templates that we make available to workspaces in Smartsheet. Smartsheet users are able to save copies of these templates for their own use (including any templated automations). What would be the best way to implement a notification that triggers each time a…
-
Automatically adding info
I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has the Date Dispensed, Name, Description of the apparel and how many they took. With…
-
Vaccination Status/Testing Report
Does anyone have an easy solution to tracking employee weekly testing? My thought is that any employee that shows as unvaccinated will receive an alert each week to upload their test results. (I don't have a problem setting that up). From there, if an employee doesn't upload the test results each week then an alert will be…
-
Automated Email Notification
I have a sheet that will be collecting data through a form. We want an email to go out to a team of people every Sunday morning as a reminder for them to complete the form for that week. It should include a link to the form. I was playing around with notifications and tried doing one to test it out. Unfortunately, I…