Format cells in sheets and reports that have an update request

Has anybody found a way to highlight (change cell color or format) a cell or row in a sheet, once an update request has been manually requested by a user? Additionally how can the same highlight be extended to reports built off of that sheet?

We have users manually requesting updates to a single column in a report, but as reports do not display the update request icon, it is rather intensive for the users to prevent themselves from unintentionally sending multiple requests for the same data bit.

Find more posts tagged with

Formulas

Reports

Accepted answers

All comments

Andrée Starå

Hi @Teresa Dennis

I hope you're well and safe!

When they send the manual update request, do they always ask for the same information, or it can be

I hope that helps!

Be safe and have a fantastic week!

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!

Teresa Dennis

Hello Andree,

The manual update request is always on the same column, but a different row within that column. I am not quite sure if this answers your question, as your sentence appears to be cut off on my screen.

Andrée Starå

@Teresa Dennis

Yes, and yes, I see that the text got cut off.

I'd recommend adding a checkbox or similar and set up an automated update request to trigger from it so it would be included with the others.

Make sense?

Would that work/help?

Teresa Dennis

I do understand the generality of your suggestion.

To confirm, we do have multiple users requesting updates, and the update may be sent to various recipients, each is evaluated on a case by case basis. If we were to use a checkbox to drive a request automation, would there be a way for one request to go to "Person A" and another to go to "Person B"?

Andrée Starå

@Teresa Dennis

Yes, you could add another helper column where you select or add the recipients, and use that in the workflow.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support 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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.