-
Merged: Automated Deleting of Old Data
This discussion has been merged.
-
Dashboard
I have a dashboard roll-up sheet that is using a COUNTIF =COUNTIFS({sheetname}, [Column2]10) formula to count the number of cases an employee has. I know the employee has cases on the sheet, but the field shows zero, instead of the number of cases that are assigned to them.
-
Dropdown multi-select columns list comparision
I have two columns that are dropdown multi-select. One column includes a list of all possible values (example: letters A-Z) while the second column includes a list of some letters (without duplicates (example: A, B, C). I would like to create a column that displays the missing letters (example: D-Z). How would I go about…
-
How can I get a multi-select dropdown column to populate with comma separation?
I have a two different columns that are populating differently, just using simple formulae: (I took out all the error checking to make it simple until I can get it to work) =[Name]@row, where [Name] is a Contact list, allowing multiple contacts per cell, and =[Department]@row, where [Department] is a Dropdown list, also…
-
Automatically send entire sheet as attachment?
Hi all 😊 We're changing a process in my company, and now we need to send specific data to the Finance department whenever we start a new project. This includes start and end dates, project number, etc. I wanted to create an information sheet to use as template with our Blueprint, so that this sheet automatically gets data…
-
Pulling data from one form to another
I am creating a sheet that will collect data from multiple regions through a specific contact. I currently do it through automation. When I fill in a specific region the email associated with this region is in the automation that I created and it populates the particular cell, and sends a form to that person. I am…
-
Columns clogging downstream sheets
Does anyone know of a way to limit columns moving from one sheet to the next sheet when leveraging Move Rows automation? I'm finding downstream sheets are getting clogged with unused columns and numerous blank cells. This creates confusion when training new employees, but also creates additional workload for managers who…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
-
Hide Unhide Columns
Hi @Genevieve P., @MMcLain, Last time I checked the Community Discussions on the subject of "hide unhide" under the categories of Smartsheet Basics or Product Feedback there were 1,076 posts about the subject going back over more than 5 years. It seems like some product improvements need to be delivered in this area! While…
-
Dynamic View accessibility
My colleague have created a dynamic vie of the Smartsheet and shared it with me and others. To access the Dynamic view, is it necessary to have a license of the Smartsheet? Or only having the access to that sheet will suffice? I'm getting attached error. Need assistance on this.
