Automatically autopopulate a cell from a cell in the same column based off the date in its row?


I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row?

For example, can I have the Associate Healthcare number from last month automatically populate into the table below it in the appropriate spot? And have this always autopopulate with the previous month's number without me having to change the formula or manual enter the number in both spots?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!