-
Unable to edit smartsheet items in Microsoft Teams
Hi all, I have a client that uses Smartsheet and will be joining our Microsoft tenant shortly. I created a Smartsheet account to familiarize myself with it and connect it to Microsoft Teams. I've created a tab and connected a sheet/report and it's showing me (View only) on Teams unable to edit. I granted a co-worker Admin…
-
form data capture
I am collecting daily sales totals and transaction totals with a form. The store manage enters the totals into a SS form daily and it populates the SS. I would like the entries to sub total into months as they are added to the SS... then those monthly totals can roll up onto a dashboard, along with other department…
-
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…