Auto-populating a range of columns with a number based on dates in 2 other columns.

Christopher Avila

Hi,

I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 USD. I would like to populate columns Jan 2022 through October 2022 with 1,000 USD in each of the columns. Is this possible? Please see screenshot for reference.

Paul Newcome

Take a look through this thread...

https://community.smartsheet.com/discussion/86327/budgeting-spread-an-expense-across-months-at-the-month-level