-
Team Member Contact shows as email address
Hi all, One of my team members was invited to our Workspace (before I came on board) with his contact name as just email address, while everyone else has "Name" then email address. In our ticketing sheet, we use an Assigned To column that is a Contact List and his name shows there but when I run a workflow to automatically…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
How to capture the Name of the person who changes the column value?
Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status). Do I need a formula for this? I used created by option in the sheet. Not sure if…
-
Wildcard workaround
Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
Customizable view options in Smartsheet Card View
I think it would be useful to be able to customize the Card view in Smartsheet grids and reports to include additional view options, such as by date or other custom columns, instead of being limited to the default options like "status", "schedule health", or only being able to view by columns that are dropdowns or symbols.…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
Merged: Collaborate without sheet view - Only attachments and comments
This discussion has been merged.
-
Add 'sort order' to Filter Views
I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.