How to Display Name of Current Month on Dashboard (with automatic updates)

kathyb

I would like to display the progress of monthly task completion on my dashboard, with the completion status resetting on the first day of each month. How can I display the name of the current month on the dashboard and have it update automatically? There is an excel formula that will do this, but I don't know how to do it in Smartsheet.

kowal

hi @kathyb,

So the fastest solution that come to my head is you need to create sheet with 3 columns:

in the first column you will have function =today(), in the second column you will the function =month(today@row), in third column you will have nested if… so it woulb be =if(month@row=1, "January", if(month@row=2, "February", if(month@row=3, "March", if….. ) and in your widget you will show always the month data from third column that will update automatically based on today() function from firs column.

Hope this helps.

kathyb

Thanks - I'll give that a try!