If Current Month

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

Hi I'm trying to write a formula that will show me a column for the current Month 


Currently formula

=If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I get an error


Any suggestions.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!