Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for September 2016
Creating Pivot like Metrics from a master sheet
I have a smartsheet which is like a master sheet with all the projects captured as one line with values like status and some key components which identifies them as unique. Earlier when i used to maintain this information in spreadsheet I used to pivot this data to give updates like which project is in which status,…
Define Range Based On Parent
I have been trying to figure out how to define a range based on the parent. So I know I can sum all the children of a parent but I want to know how parse all the grandchildren or great grandchildren for specific data. I can define how many rows to the last row is under a parent but I can`t use that number to define the…
OneDrive - Central Account
I know you can upload from OneDrive to Smartsheet and the document actually be stored on OneDrive. The problem is I don;t want documents stored in each individual person OneDrive. I want any document uploaded to go to a common OneDrive account. Basically if I share a sheet with an external user and request files from them…
Drop down list column \ multiple choice
Dear support! Could you please help me to understand if it's possible to use multiple choice in a column with drop down list? I mean that maybe there is a way to create something like that?
Make Collapse ALL default
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
Problems with LOOKUP formula
Hello, I'm encountering an issue with the LOOKUP formula in Smartsheet. Apparently it doesn't work with the names that I use in my lookup range (note that I dragged the formula down to the bottom, using "$" to block the rows of the range, but I get no results): I would like to understand why it is not working and if there…
Update row Webhook triggered when filtering rows...
The update webhook got triggered if I delete rows and also when I filter in my page. Is there any way to avoid it and get only webhook when data changes, not if a row is filtered, deleted or moved? I'm working wht zapier, and I get a lot of "false" updates due this issue.
FF dependecy to push Finish Date, while holding Start Date
Let's say I have two activities, A & B. A has a Start of 3/1/2016 and did indeed start on 3/1. However, it cannot finish until B finishes. So we put down B as a predecessor to A with a FF dependency. The problem I'm seeing is that as B Finish Date gets moved around, the Finish Date for A also moves, which is great; but the…
Accessing a web form on Android app
Is there a way to access a web form on the android app? I can access the form on the desktop version and through the email link but I don't know if it's accessible on the app. Does any one know?
Show values in the chart
I have created several reports for my PMO and I am using smartlabs to create charts. I want to show values on th line chart/ bart chart. Current functionality is , you have to hover on the chart to find out the value. Is it possible to show the value up front on the line chart?