-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
Keep child rows collapsed to the parent row at 100% completion
I like to collapse my rows to just see the parent row when the child tasks all reach 100% (I don't want the rows to to be removed from the report - I know it's an option not to display them when they reach 100%. It seems that, when I collapse them manually, some or all of them are open the next time I open the sheet. I…
-
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
