-
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…
-
Automation - need a required for meeting reminder
Hi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and stakeholders which they then reply to if they can make the cal. I have made a required members tab, with multiple contacts in…
-
Why is there a restriction on the number of e-mail addresses in a cell?
Hi I use dynamic view where i have linked a cell in the database to determine who has access to specific part of the database. I have now encountered a restriction of max 20 e-mails in a cell. This has a major impact on my solution, because I need to have more then 20 people access to that data. So why is there a…
-
Row number no longer in notification emails.
As of this morning Smartsheets comment notification emails no longer include a row number for the comment in question. My users are still able to click the link to go directly to the row where the comment was logged, but some of my users reference the row numbers from the email and this leaves them out of the loop. Is this…
-
viewing users who have made transactions
Hello , When a change is made on the page, I send a notification e-mail to the users. I see the name in the incoming e-mail who made the change here. but if more than one person wants to make changes on the same line, I cannot show the users who made changes on which line. Is there any other method for this?
-
Send Email when any Cell except 1 changes
Hello, Is there a way to send an email when any cell except one changes? I have a field called job status. I need it so that if any field except job status is updated to send an email. What would be the best way to go about this? Thank You, Douglas
-
How to calculate No.of days without getting the value changed everytime a new row is added.
Error with the No.of days due column. If there is an automation set to send an email whenever the number hits 14, the value in this column keeps getting changed whenever a new row is added. Based on the formula, it changes to 14 first and then realizes it isn't 14 and changes back to 13. Due to this, repeated emails are…
-
Our automations aren't sending notifications or updates... Is something wrong on the SmartSheet side
We're testing this morning and can't get SS to send any updates or notifications. Trying to rule out it being a SS issue.