Hi,
Sure, I posted about it yesterday here as well.
But this question is just to see if an approach to solving the larger challenge is possible.
Put simply, if you were trying to have unrelated data (in terms of database relation) reference each other across a grid, how might you do it?
In my specific case, I have a calendar…so cells in columns that visually correspond to a day and a time of day (one cell might ‘mean’ Friday at 9am, for example,). And I have rows across those columns from a data collection that represent specific database items (boats).
What might be a good way to work with formulas in each individual cell (row+column ‘mapping’), so I can conditionally alter them?
For example: "
Boat 1" (in row 1) has no ‘bookings’ (another collection/data item) this Friday at 9am (column 6). Show nothing in row 1, column 6.
But “Boat 2” (in row 2) does have a booking at that time, so indicate that (shade it a different color, show an icon, etc.) in that specific cell: row 2, column 6 (i.e., it can’t float ‘up’ to the row 1, column 6).
Lastly, there will be roughly 600 cells visible in the end (multiple boats x multiple ‘time slots’ x ‘days of week’), so creating individual variables would not be practical!