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

Options
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! 

 

Thanks

Comments

This discussion has been closed.