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.
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
For my dashboard (Sights), I show status updates from individual projects. There are multiple updates columns per project I have to pick up. For now, I added extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).
Having updates in a project sheet itself makes messy since I had to add several additional rows to all project sheets. But in this way, people need to deal with only one sheet.
Alternatively, I could create a dedicated sheet and have my guys update their updates there. But this makes people update 2 different sheet, and for me, I have to cell-link a lot to the master sheet from different sheets.
Perhaps other ways to do better. Please let me know your thoughts, how you have done if you have done!