▲ 1 r/googlesheets
Populate a cell with a date range if any cell in a range on another sheet equals the number of its row
Hey all! Just working on a little recreational thing.
I want column C of the "Goals" sheet's cells to populate with a date range of [Monday after next] to [Tuesday of the week after that] if its row number appears in C20:I26 of the "Card" sheet.
How can I make that work?
https://docs.google.com/spreadsheets/d/1oBQxlmUUlfn9Fl4HLgTXCFdBxQ37R9yK-_S6N-51CZo/edit?usp=sharing
u/Baxder — 4 days ago