Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Sight Cell Linking
I want everything that is under a Parent Row on a Sheet to show on our Dashboard.
Is it possible to cell link ALL children under a parent row to a Sight/Dashboard?Β
Β
Examples:
If any rows are added they will be included
If only one row is populated, only one row will show in Sights
Β
Β
Comments
-
I use a system like this for what you are doing:
Β
1 - add a flag column to your sheet. Flag any rows you want to either include (or not include) in your dashboard
2- make a report that includes any rows where the flag has been checked (or unchecked depending how you want to go about it)
3 - make a report widget in your sight and link it to the report you made
Β
Now the sight will update on a continual basis whenever you flag/unflag a row because of the report criteria
-
Thanks!Β
Β
So everything is manual when it comes to "selecting" rows?
If a new row is added, I'll have to go in a manually check or uncheck the flag, correct?Β
Β
-
You don't have to flag each row. i wasn't sure if you only wanted to see the child rows in your sight. Β You could add a flag to just the header row to exclude that if needed and then unflag everything else.
Β
Set your report criteria to only show things that are UNFLAGGED
