-
FEATURE REQUEST: Auto Update
I've been working for the better part of a month on integrating smartsheet into my department at work. The ONLY issue is that we have up to 8 people editing the same spreadsheet at one time. Some of us might write on 3 lines in a row within 30 seconds. I need other people in the department to be able to see what lines are…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
-
Data Entry With a Filter
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The sheet is long so I create a filter to pull up a specific vendor. In the first blank row under that vendor I type in the…
-
Smartsheet has stopped displaying tabs?!
Hi Smartsheeters A couple of months ago (?) my Smartsheet instance has stopped displaying my open sheets in tabs across the top of the screen. It just gives me * Home tab * One single open sheet * The [...] tab * The [+] tab I can still open sheets from the Home tab, and I still see all my open sheets displayed in the…
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Is there a way to set a default sort order on a sheet?
I have an open issues list. I would like it sorted by open/closed, then by priority. I can do this manually each time, but I would like that as the default anytime someone access the sheet. Is this possible? Thanks. Wayne
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Is it possible to grant access to a folder without granting access to the whole workspace?
Im hoping someone can help me out, I am fairly new to SmartSheets. In my organization, we have created a Workspace called PMO - Projects. This workspace has a folder for each department and within each department there is a folder for each project we are running specifically for that department. We have configure this to…
-
Shared Filters Not Working
In one of our sheets I want the ability to "force" users to view a sheet through a filter. We have a lot of rows that are added on a daily basis and I want those rows to be hidden if the completed column has been checked. This makes it easier to navigate the sheet and find the open actions that need to be addressed. So I…
-
Set a task that has a set (firm) date and predesessors
Hi, Is it possible to set a task with a "must occurr on date" with a duration and Predesessor? Exmple of use: I have some tasks that people need to complete before I send them on an external training course. The course has a set date and cannot be changed. Therefore I do not want the course date to change in the task list…