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 January 2016
Discussion List
How do I share selective sheets within a workspace?
When some staff doesn't need access to everything in a workspace, how do I share only selective sheets? Please help. Thank you!
importrange function
We use the importrange function reguarly within our Gsheet implementations, and would like to allow certain cells in smartsheet to receive regulary push updates from an active gsheet via this function. Is there a way to do it? In example, we have a productivity tracker in gsheet that is calculating various % complete…
automated movement between parent grouping for roll up sheet?
Is it possible for a row to "automatically" relocate itself from (1) parent child grouping to the NEXT parent child grouping? Right now, I have to manually move them. I have a roll up sheet for our design clients. The roll up sheet is organized by stage of process and all information is auto filled in from the actual…
Predecessor numbers automatically updating
When I add new lines to the sheet, the predecessor numbers do not automatically update to the change in the number to the task to which it should be linked. How can I make sure they update as I edit the sheet?
Calculate days remaining
I have an estimated project Finish date of 8/9/16 in a column "Finish". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4. I attempted to use the formula: =NETDAYS([Finish]6,[Finish]4) I get no result or error message. Just the formula. What am…
auto numbering sub-items
Is there a way to auto number sub-items that have been indented? I know you can auto number all of the rows, but that doesn't change anything from the basic row numbers. You can add a suffix (.1), yet it applies that same suffix to all the rows; defeating the purpose. It would be much more useful (unless it can already be…
Images in Dropdown list
I have a dropdown list that contians three companies to indicate who owns a requirement in a requirements accountability matrix. This works fine but now that Smartsheet can have images in a cell I was wodering if I could assign an image to each option in my dropdown list? So, when I select a company from the drodown the…
phone numbers
how do i make a phone number in a cell able to be clicked on so that my phone recognises it as a number and auto selects the phone function?
Security: why is a stranger requesting access to my smartsheets?
Received an email today from smartsheet saying some stranger is requesting access to one of my smartsheets. How is this happening?
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…