-
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…
-
Meeting Minutes In Project Plan
Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank meeting minutes form for a call, complete that form, and archive those minutes still in that specific subsection of the…
-
Auto Assigning Values In Smartsheet
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I would like for the value of percent completed to auto-fill to 0 Whenever a new task is made, and leave it up to the employee…
-
How to return only the most recent entry before a targeted date range?
Hello, I currently have the following asset booking sheet: What I'm trying to do is, for the column 'Assignee in Possession Before Your Booking Date:', if the asset is available within the booking date range that the user has entered -- I would like the column to display what assignee will have the asset last (most…