Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain.
I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content.
I have another sheet, in card mode, where I can manage basic daily tasks. When I add a task, I add a date and I'd like this task to also appear in the calendar I made, next to the date.
Finally, I have a regular task sheet. I'd also like this task to populate my calendar automatically. Is this possible using smart sheets? But I'd also like to be able to add content manually to my calendar.
By the way, I don't like the calendar view of
Comments
-
Hello,
You may be able to create a VLOOKUP function that references your date value in one sheet and returns the value next to it in your calendar sheet.
More information on VLOOKUP: https://help.smartsheet.com/function/vlookup
More info on cross-sheet references: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
