Hey,
I have a table as follows:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Activity
[/TD]
[TD]Duration (days)
[/TD]
[TD]Date
[/TD]
[TD]Start Date
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]today()
[/TD]
[TD]today()
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]4
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]7
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
There are a number of activities that require a set amount of days to complete and a defined start date. I will filter the table so some activities will not be included, and I will rearrange the table so that the top cell is not constant (i.e. perhaps we will do activity B first).
Setting up the table so that each cell referenced the cell before is not a problem, BUT making it so that the top cell in the date column is always defined by a cell elsewhere in the sheet has me stumped.
Any ideas?
I have a table as follows:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Activity
[/TD]
[TD]Duration (days)
[/TD]
[TD]Date
[/TD]
[TD]Start Date
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]today()
[/TD]
[TD]today()
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]4
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]7
[/TD]
[TD]today()+previous
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
There are a number of activities that require a set amount of days to complete and a defined start date. I will filter the table so some activities will not be included, and I will rearrange the table so that the top cell is not constant (i.e. perhaps we will do activity B first).
Setting up the table so that each cell referenced the cell before is not a problem, BUT making it so that the top cell in the date column is always defined by a cell elsewhere in the sheet has me stumped.
Any ideas?