Create Weekly Alert on a Dashboard

ygoldgrab
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

Best Answer

Answers