-
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).…
-
Is there a way to prevent users from moving on to next cell...
...without entering a value in a particular cell? For instance, I want to make sure that users enter a ZIP CODE is a row - If they do not, I would an error/warning to pop up or, at least, inability to save the entry without entering the ZIP. Any suggestions?
-
Importing Comments from Excel
Hi, Is there a way to import comments made in the individual cells from an excel sheet to Smartsheet without having to retype all the comments?
-
Text toolbar on report
The reason we decided to use Smartsheet is because there is some information my colleague and I need to share with each other (for instance contact names, emails, and renewal dates), but other information is purely of interest to one of us and not the other. I had the idea to create a filter for columns the same way I do…
-
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…
-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
Automation
I have a sheet which has all of the training details of people who work for us. Previously I have set an action every week to email people whose certificates have expired to remind them to send me their new certificates. I want to use the new automation function to do this for me, however I can't see how to trigger it...?!…
-
Sum of Values in Another Sheet, Using Collect
I would like to find the sum of the enrollments in a particular course from one sheet (Sheet 1), and display in another sheet (Sheet 2). Sheet 1 There are three columns, Course, Students, Term. Course | Students | Term BUS 101 | 12 | Summer BUS 101 | 33 | Summer BUS 101 | 15 | Fall ACT 223 | 16 | Fall CAR 322 | 4 | Fall…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…