I create a data sheet that connect to calendar app. I have a column with checkbox. is there a way that if I check the box in that column the data on that role will show in calendar app
Hi @Jessica Im
There are two ways you could set this up. You could either put a Filter in your Calendar App so that you can easily identify rows that have the checked box, but the main Calendar would still show all of your rows (checked or unchecked).
Alternatively, you could create a Report in Smartsheet to only pull rows that have the checkbox checked, then use the Report as the source of your Calendar instead of the sheet. Would this work for you?
Let me know if you'd like any further clarification of either option and I'm happy to provide screen captures to illustrate the process.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.