-
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…
-
Merged: Column border style
This discussion has been merged.
-
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…
-
Report Layout with Multi-Select Dropdown Column
I am asking for assistance on a report layout. We have 15 Regions. Each Region has small teams. I have some team members that are on several teams. We have a column called “Region” that is a multi-select dropdown column. We like the report that outlines every region’s team members. The report is sorted by region first and…
-
Merged: Auto sort rows in sheet
This discussion has been merged.