Goal: We are trying to have reps be able to upload documents after their initial form fill. For them to be abe to go back and do a modification – how does that look in smartsheet when the info comes back? how can I get that setup?
@JenaW You can create a report with current user as the filter so that each rep sees only those records applicable to them and make changes. Also the columns should be unlocked depending on their permission level.
@Razetto We would like it to be in a form view. So once they obtain their approval, they will need to open back up the form and attach their pdf. Is that possible?
@JenaW You can set the sheet to trigger an update request after an approval, they'll be able to attached their pdf. Include the attachment field with the message
@Razetto The problem is that the approval is not happening in smartsheet.
So first they have to get approval from the VP, this is an automation in smartsheet. Once they get notified whether or not the VP approved, they will get a notification with a link where compliance will either approve or deny them. If approved, they will get an attachment. This is the attachment that needs to be uploaded to smartsheets. But that is the issue, that they are using an outside link to get approval
@JenaW If I understood correctly, the VP approval happens in sheet1 while the compliance approval is outside the system and they provide the attachment that's filled out by the rep which then it has to be uploaded on sheet1. You can create a unique ID in Sheet1 and in the VP approval notification include that unique ID and the link to the report that I mentioned to you before in the body of the message. Once the attachment is filled out they can refer to the email notification, open the report link and use the unique ID to look at the specific row.
@Razetto Yes sort of.
VP approval happens in sheet1 while the compliance approval is outside the system. 2 different scenarios:
Does this type of automation make it easier?
Based on you description, I agree that an Update Request is the best way to proceed!
I would personally use the Record a Date workflow to add in the day that the VP approved in one column, triggered by the Approval. Then you can set a Date Based automation (looking at that Recorded Date if it's 1 day ago) to send 2 possible Update Requests with different instructions in the email (using Condition Blocks to filter based on $).
Here's more information:
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.