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 2015 Posts
Archives for June 2015
Discussion List
Creating Governance and Structure around SS Implementation
Has anyone established best practices/documentation around governance and incorporating Smartsheet into existing operations? If so, would you be willing to share anything you've developed and/or talk over the phone? Thank you, Dean
Using a Child cell as a constant in the Grandchildren cell formula
So I have a Parent row, Children row, and Grandchildren under the Children row/cell. On the Grandchildren row I want to take the Child cell divide it by the Parent cell and then multiply it by a cell on the grandchild row. I think I have a good formula - if I just can figure out what to call or how to indicate the Parent…
Smartsheet Directory
I made a directory listing all of our smartsheets with a brief discription of the sheet. I made the name of the SS a hyperlink that takes you to that SS. I then shared the directory with my office. My problem is if there is a sheet someone in my office wants to access but the sheet has not been shared with them then I want…
Filtering a Report
I like the fact that I can create reports from one or multiple sheets and choose the fields that I would like to display. I would like to be able to filter the columns when I'm looking at a report, but that doesn't seem possible. Filtering would allow the users of the report to hide the info that isn't relevant for them. I…
Recurring Tasks
Does anyone know how to create recurring tasks in Smartsheet?
formula help with symbols added
I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission…
Payroll
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
Do you support "Hammock"?
Do smartshett support hammock?
Power Function from Excel
I converted a power function from excel "=0.8*(POWER((9600/1000),-0.5))" and once imported it comes up as an "unexpected opperator". Is there another work around?
Personal To do list
Hi, Is there a way to send a personal to do list that is created as an amalgamation of one person's tasks in multiple smart sheets? i.e. If John Doe needs to do X in Project A, Y in Project B and Z in Project C, is there a live to do list that lists this for him? Where if he checks it off it gets updated in all smart…