I have a main page in which i am going to have an announcements section at the top.
The info for the announcement is stored in another google sheet separate and has a button which enables the visibility. As it is a different sheet i am unable to display the data in the main page as that uses its own sheet. Not sure how i can do this. I am using a custom collection for the announcement box which doesn’t give the option to choose the sheet.