Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Help

Brett Wallace
edited 12/09/19 in Archived 2017 Posts

This might be simple, but I can't figure out a good formula for dates.


What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. 


Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments made in each year.


Hopefully this makes sense and someone can help! 




This discussion has been closed.