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 organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to keep the values from each month so we can show trends. There are also other metrics that need to be enterred initially, and might be updated occasionally. I need to create a report for stakeholders that shows the current month's metrics for their business. This report will become the "single source" of truth...so once it is generated, we don't want people to be able to change their values. I don't know if I should create multiple sheets, or just one sheet, and do I put the monthly data values in a series of columns (e.g. jan value1, jan value2, feb value 1, feb value 2) - or use multiple sheets for each month?