-
Listing unique values in a column, and counting them (group and sum)
I have to import a list of orders and count how many times each unique product was ordered. So the orders may list the same ITEM hundreds of times (eg: Item123 x10 pieces). I want another list or sheet which displays a UNIQUE list of each item, and a COUNT of how many pieces of that item was ordered. As my order list…
-
Chart on Sights
Hi, I created a chart on SS labs. I want to display the chart on my project dashboard. How can I do this? Y
-
Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
-
Sight Cell Linking
I want everything that is under a Parent Row on a Sheet to show on our Dashboard. Is it possible to cell link ALL children under a parent row to a Sight/Dashboard? Examples: If any rows are added they will be included If only one row is populated, only one row will show in Sights
-
Edit information on Sight
Administrators for particular Sight sheets should be able to create widets that allow the user to edit the information. For example: If I am presenting to a team of people using Sight, the layout allows for a clear reflection of information, which is awesome! The problem is if the presenter wants to make a change to a…
-
Calendar in Sights
Is there a way to display a calendar on a sight? I want to create a sort of home page for our department using sights and it would be great if I could add a calendar of upcoming events and have it look like a calendar. I can use a report but it won't show up in calendar view.
-
Share a Smartsheet folder to auto update added sheets/reports on Sights
Hi, Is there a way that I can share a folder with my team? I want to add the folder on Sights so that when new sheets or reports get added in that folder that it is already accessible in that sights folder without me have to go and add it manually everytime? Or any other suggestions on how new sheets/reports can be…
-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
-
Sights
I am using smartsheet to collect problems and ideas coming from various areas of our company. As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas. My query is where is the best place or method to gather all the…
-
"Send Row" opens Pop Up Window from Sight
Hello, I am trying to manage requests from a customer with my local team of people who work on the requests. I love the comments, attachments, that can be added into a row, and the ability to create a sight with different reports. I have created a web form for my customer to input requests, but I would like a clean way for…
