-
Automatic Archiving
I'm creating a weekly schedule in a sheet and I would like to automatically archive that sheet after the week is finished, and save it as the name of that week. Does anyone know how this would be done? Thank you!
-
Linked Sheets for Templates
I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here. I am creating project templates in smartsheets for our project managers. I am doing this by creating a 'Master'…
-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Alert when adding a new row
Hi, We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by…
-
Cell Linking Issues
Hi all, Is anyone else having issues with cell linking? I can no longer get it working.... It was all fine until about 4 weeks ago and now nothing will link?
-
Sharing Reports
Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report. Is this possible? This is in regards to…
-
Google Sheet Sync into Smartsheet
I realize Smartsheet allows sync for Google form; however, does it allow sync for Google sheet and vice versa?
-
Displaying a date in a non-date column
I am trying to display the earliest date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted…
-
Data from one sheet form to populate another
I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to sheet one (main sheet) via…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.