-
JOIN, COLLECT with MATCH
In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + "," I have a set of values in Sheet 3 that…
-
Adding a new Column to multiple workbooks
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
-
Link to a Google Drive Sheet from a Dashboard
While I have tried everything, it seems, whenever I click on my newly-created dashboard item that links to a Google Drive Sheet (Google Sheet), it is asking users to "open with?" Is there a way I can have users click my link and go directly to the interactive sheet without choosing anything?
-
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…
