Explore. Ask. Answer.

or Explore Discussions

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

Christopher AvilaChristopher Avila ✭
in Formulas and Functions
01/11/22
Answered - Pending Review

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


Tags:

Answers

Sign In or Register to comment.