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

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.

Explanation of question - Smartsheet.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!