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.
Discussion List
Calendar view in Sights
Is there a way to show a calendar view in sights
background colors in Sights
IS there a way to change the background color for a widget in Sights. Currently is only changes the background on the text and not the entire cell.
Return a value based on a date
Hi there everyone, I have posted before but am still stuck. https://app.smartsheet.com/b/publish?EQBCT=5b60441a73dc4bfe9c4e77977e0cce7c Hope this is helpful and clear.
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…
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…
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…
LOOKUP() Function
Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
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?
