Create Weekly Alert on a Dashboard

ygoldgrab

Hi, I want my Dashboard to display a specific message every Monday and a different one every Thursday.

I tried searching the community but didn't find anything.

I used the following solution. Is this correct? It seems to work. Any other idea? Thanks

I created this on a metric sheet=IF(WEEKDAY(TODAY()) = 2, "Remember the ....", IF(WEEKDAY(TODAY()) = 4, "Remember ....", "")).

The problem was that I wanted to highlight this area on the dashboard only if there was text.

I used conditional formatting on the metric sheet to highlight the cell if it contained "Remember" and used "use cell formatting" in the widget

Andrée Starå

@ygoldgrab

Yes, at a glance, it should work.

Unfortunately, I can't think of a way for the user to hide the alert, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

✅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!

Andrée Starå

Hi @ygoldgrab

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

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!

ygoldgrab

Thanks, Really, I just wanted to display a simple alert (highlighted text) to our company on our dashboard every Monday. -- And the rest of the days it should be blank.

Question was, if anyone had any ideas how to go about doing this.

ygoldgrab

Also, would there be a way for the user to hit an x and close/hide the alert?

Andrée Starå

@ygoldgrab

Yes, at a glance, it should work.

Unfortunately, I can't think of a way for the user to hide the alert, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

✅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!