-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
Cell Linking
Hi all, I have currently set up cell linking, however I only want it to cell link once the drop down box has been changed to 'Converted'. As in, we receive a lead and add the data to that lead. Once that lead is 'won' or 'Converted' I change the drop box to show this. Once this is done then I want it to move onto my other…
-
SCC Nesting Summary Data
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)
-
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?
