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