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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!