Hey,
I have a table as follows:
<tbody>
</tbody>
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:
Activity | Duration (days) | Date | Start Date |
A | 2 | today() | today() |
B | 4 | today()+previous | |
C | 1 | today()+previous | |
D | 7 | today()+previous |
<tbody>
</tbody>
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?