-
Creating a dashboard from a sheet with multiple data types
Hey all, attached is a screenshot of a sheet I am trying to create a dashboard with. The issue I am having is creating a chart/view to show completion of a year review meeting by student. The 'Complete?' check box is what we are using to mark completion of the meeting. When I try and make a dashboard from this sheet and…
-
How to create a source sheet that automatically updates other sheets if data is removed?
Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added…
-
How to append sheets/consolidate multiple sheets in one sheet
Hi All, here are two different sheets populated from two different forms which are site specific The forms have information for people to read which are site specific hence why two forms Is there a way to append these two sheets into one like you can do on power bi using the append query function? please can you advise
-
Lock a row (preventing editing) while row is open
Hi there, we have a scheduling Smartsheet that we're having some troubles with. Users are booking appointments in the below view, but since the row isn't locked out while this is happening, we're ending up with double-booking because two users overlap using the row. We have multiple people in the sheet, so if two people…
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…
-
How do I search for duplicate data within a sheet?
Hello everyone! I am very new to Smartsheet and new to my position as a New Product Development Coordinator. My company utilizes Smartsheet to track new ideas for products as well as the progress of the projects done on them. We have a master sheet that all the ideas are filled into from a form showing who submitted the…
-
Pulling data from another sheet (vlookup?)
Hello, I have a question about pulling data from another sheet and I'm hoping there is an easy way to do this. So I have 2 sheets, one is my main sheet with all my data (collected via form), and another sheet is my roster. On my main sheet, the Employee name column is a single selection drop down menu with my employee…
-
How do I have 2 owners for a sheet? What if someone deletes some data & team needs to recover data
Is is possible to have 2 owner for a single sheet. What if someone deletes some column/row from the sheet and there is no way to get the version history or restore the data, if the only 1 listed owner is there but on leave. How do we get this in place, without really waiting for original owner? It would be nice if there is…
-
End Date Formula Work-Around when Dependencies are Enabled
Hello! I am working in a sheet where I need dependencies enabled because we are using the GANTT view to show in a report on a dashboard, however I also need the end date of that sheet to be calculated (it is calculated based on another date in the same row). When dependencies are enabled, I'm not able to put a calculation…
