collecting live information on a specific date

Options

Hello community, I have a drop down column with stock status. It changes almost daily ; I need help creating a formula to count each status on the last day of the month (it could be the first if it's easier, 30th vs 31st as opposed to 1st). How do I do that? I know how to create the formula to count but sometimes I'm too busy on that day to go collect the results, so how do I trigger it on a given day and then I could create a notification to go copy the information on that day before it changes again OR how do I create a formula retrieve the information on a given date in the past (ideal situation)

Hope this is not too confusing.

Thanks

Diane

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!