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 October 2016
Discussion List
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
Creating A Template
The project that I'm working on is reoccuring every year. I was wondering if it is possible to create a template for this project event that I can just queue up a fresh one every year?
Sharing Resource Views
Can somebody advise on how I set up Sharing Resource View. New to smartsheets
Update requests with predecessors?
Hi all, I am trying to send out update requests with Smartsheet with tasks with a predecessor, but the other user is not able to make a change. I would have assumed that if someone needs to update the sheet, even with a predecessor on the task, this should show and allow for the change to be made? Any help is greatly…
Can't get column data from more than 1 sheet
I am trying to prepare a report filtering information from 2 different sheets, and I need 2 columns from each sheet. When generating the report only data from one sheet is reflected in the report and the columns from other sheet are blank. What should I do.
Conditional Formatting Based on 2 Different Cells
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
Numeric Column Type
Has anyone noticed that the alpha/numeric column doesn't sort properly when numbers are in the following format: 1.5.1.1, 1.5.11.2...........11.5.11.40. You get this: 1.5.11.1 1.5.11.10 1.5.11.11 ... 1.5.11.2 1.5.11.20 1.5.11.21 ....... 1.5.11.3 1.5.11.3 1.5.11.31 ... Would a purely numeric column type take care of this…
Possible to share filters?
I have created quite a few saved filters. (I am in love with this new functionality by the way.) Now, I want others to be able to see these saved filters and apply them while they are viewing my sheets that are shared with them. Is it possible to share filters? How?
Web form with restricted access
Hi all, I want to use a webform to collect details from my employees prior to their individual one to ones. They would recieve the webform on a monthly basis to complete. I would add any agreed actions to the sheet so we have a record. However, the information will be confidential and I don't want one employee to know what…
Sights Templates
will there be Sights templates added?