Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formula to capture data in a cell on last day of the month.
I'm trying to figure out a formula that will capture the data ($) that is in a cell (on another sheet) on the last day of each month. Is this even possible?
These are items that will move/change frequently so I just need to lock in the numbers at the end of each month and would prefer it to not have to be manual.
Can anyone help?