-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets cleared…
-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
Reports Exportable to Outlook Calendars?
Hi there, Are customized reports able to be published to Outlook 2013? Thank you!
-
Additional workflow/automation actions
Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example),…
-
File attachment counted as a change to a row
I currently have two workflows set up: (1) Payment approval request after an event: employees submit request with invoices attached as a file for approval (2) Payment approval request before an event: employees submit a request for an approval, the request gets sent to a supervisor, and once the supervisor approves, an…
-
Recurring Update Requests until task is complete
I have a workflow where a contact is sent an updated request when they are added to the row. What I would like to know is how to have that update request sent regularly (daily, or weekly) UNTIL they have submitted the update request. Then I don't need them to get the update request anymore. Is there a way to do that?…
-
Automatically request updates weekly without a trigger event
We have created a new Smartsheet for our quarterly goals including an Assigned To, Status and % Complete fields. We would like to have an Update Request send out automatically at 8 am every Monday morning asking for people to update their Status and % Complete fields every week. I tried going in and creating a new Update…