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 April 2016
Discussion List
Shared To Me and grouping sheets/workspaces
Right now I have about two dozen sheets shared to me. That number is about to significantly increase... because the people that are sharing the sheets with me work on different projects, is there a way to "view" or "group" my shared sheets other than by clicking on the Location or Owner header to sort? Say, one group for a…
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells…
Sheet Title in a cell
Is there a way to pull the sheet title into a cell within the sheet?
Installation schedule report in Calendar View
Hello All, I am trying to set up a report in calendar view for our installation department. We have multiple trucks that we dispatch daily and would like to know if anyone has successfully set up and use this feature in Smartsheet? We are currently using Microsoft Exchange Calendar as a tool for our install schedule. Thank…
Conditional Link/sheet
Good day, I am a user of Smartsheet and am wondering if you guys can assist. First I will try to draw your kind attention to the task I would like to do in smartsheet, as below: Sheet 1 ITEM DESC COST1 COST2 BCOST DATE PERCENTAGE AA WOOD £12.00 £13.00 £12.50 12/4/16 12% CC FOOD £15.00 £11.00 £12.50 12/4/16 9% Sheet 2 ITEM…
Creating statistical reports
Hi All, Could you please advise if it is possible in Smartsheet to creat statistical reports? For example, I have Training schedule list, where one company is having a lot of types of courses. I need to see the report where I can find number of trainings which one company had for last month. Thank you in advance!
Gantt Chart Conditional Formatting
Are you able to set up in conditional formatting for the Gant Chart bar to be set to a certain colour based on the fields in the row? Otherwise can you set so the gantt chart bar is set to a new colour for each sheet within a workspace?
Parent/Child Columns
Would anyone else find it useful to be able to assign a status of child to a selected number of consecutive columns adjacent to the designated parent? For me this would be useful in quickly hiding and unhiding child columns, and for including child sums in the parent, and for making sure that any new columns so added would…
Webform to Create Discussion post
I don't want people viewing my sheet but want to be able to gather comments on projects. Would love to have a webform that has a pull down for someone to select a project (row) and then add a text field in the webform that populates the "discussion area." Know if this is possible?
Automate Reminder to my team for sheet updates every Friday
How do I do this? T