Having calendar view pull from today's date


Created a report to reflect the calendar view of a sheet and the oldest date is being shown instead of today's date. How can I make the today date be the default?

I added the following formula into the sheet but isn't working: =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!