Create Weekly Alert on a Dashboard

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
Best Answer
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
Also, would there be a way for the user to hit an x and close/hide the alert?
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.