Dashboards & Formulas

Options

Hello, I have (2) fields on a sheet that are driven by dates.  here is an example:

=if(and(today()>=date(2019,9,1),today()<date(2019,10,1)),"Period 1")

So on the first of each month, this field on my dashboard should update to the current month.  For some reason, the dashboard will only update if the sheet is opened.  is there a way to make this automatic?  it kinda defeats the purpose of utilizing the formula if i have to open the sheet in order for it to execute.  

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!