Can a Display Message be Created When a Report Has No Data to Report on for the Week?

Hello,

I created a Report regarding issues that need to be escalated to leadership. I was able to link the report up to our folder and get data to run through the report to show what I needs to be reported on.

Since there are weeks when issues will not require escalation and the report appears blank, I am looking to have a message appear in the report. For example, if there is no issues that need to be escalated to leadership for this week, I need a message to display "There are no reported issues requiring escalation at this time."

Is this possible?

Thank you!

Find more posts tagged with

Reports

functionality

Accepted answers

All comments

Andrée Starå

Hi @Terry H

I hope you're well and safe!

Yes, you could add a so-called helper column or a formula somewhere that checks if there are any issues, and then it could populate a message as needed.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Terry H

Hi Andrée,

I've seen a few forum discussions on using helper columns but I am not sure a helper column would work in this case as I am using a Report rather than a Sheet.

I can explain what the current process is better. The image I have below is a Report that connects to a Workspace with multiple Logs. In the Workspace are logs that are created when a new project is started and logs are removed when a project is deemed complete. The Report is meant to pull information from the log and look for Open Issues with an "R" for health.

Would it be better to use a Sheet connected to a Workspace in order to display a message as such instead of using a Report connected to a Workspace?

If a Sheet is better, is there a way to automate the Sheet to add connections to any new logs that are created?

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.