Update Requests - Displaying (via Reports or Dashboard)

Mike Rini · 09/01/20

Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could build a report, dashboard, etc. that showed all the Pending Update Requests.

Mike

Andrée Starå · 09/02/20

Hi @Mike Rini

One idea I had would be to trigger an Approval Request simultaneously with each Update Request and then change the status through an Update of a specific field from the Update Request.

You could then filter and show them in a Dashboard.

Make sense?

What do you think?

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Rini · 09/02/20

Conceptually, makes sense. Are you saying have someone manually update the Status in the Update Request?

Andrée Starå · 09/02/20

@Mike Rini

No, not manually. It should be a value that is always getting updated from the Update Request.

Make sense?

Mike Rini · 09/02/20

It does, I just didn't think SmartSheets had the capability to update a status based on an Update Request. That was something I was looking into a couple months ago, but it didn't exist. Does it now?

Andrée Starå · 09/03/20

@Mike Rini

Excellent!

The update request can update almost anything depending on permissions, locked columns, formulas in cells, and a few other situations.

In your use-case with changing a status, it should work.

Mike Rini · 09/03/20

Awesome, so let me ask this question so I don't have to fumble around with it for 2hrs. Let's say our Status says "Sent To Account" when the Update Request goes out. When Account submits the Update Request, what would trigger mechanism to update the Status? I assume I can look at the fields filled in as changed, but am not sure as to how I change the Status field from "Sent To Account" to "Account Submitted" (in our case).

Thanks for all the help.

Andrée Starå · 09/27/20

@Mike Rini

Apologies, I missed your reply.

They would need to change the Status value manually (in the update request) to show that it's updated.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Rini · 09/28/20

Yeah, that's what I was thinking. I was working on this last week and was struggling to figure out how it change it automatically. Can you also clarify how I'd be able to show a list of open Update Requests on either a report or Dashboard? Above you mentioned a combination of Update Requests/Approvals - I'm familiar with using both, but still not totally clear on how to show what's approved/updated in either a Dashboard or Report format

Andrée Starå · 01/04/21

@Mike Rini

I hope you're well and safe!

Excuse the late response.

Crazy times and I missed coming back to you.

Have you solved it, or do you still need help?

Happy New Year & Stay safe!

Harry Luk · 12/01/23

i'm wondering the same thing

i need to see and find all the pending "update requests"... they are to-dos

and is there a way to send them again if it's not done after a few days?

Formulas and Functions

Formulas and Functions

Update Requests - Displaying (via Reports or Dashboard)

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Created Date of Row Copied from Another Sheet

Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025

Writing a reference formula with multiple IF/AND situations