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 March 2016
Discussion List
Parent/Child relationships
I have a master document for my product codes. Several products have multiple parts that come together to make a whole product. On my master I have parent/child or indent relationships built. However when I run reports off the master the parent/child relationship doesn't carry over. Is there a way to make it carry over?…
Conditional Format by cell unique based on row or column
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
Freezing Columns Creates Two Scrolling Panes
Being used to Excel and setting up Panes for large sheets, we were delighted to find that if a column is frozen well to the right in a sheet, the "freeze" line can be drug to the left to make both sides scroll horizontally. Hope this is a helpful hint for someone searching for Panes.
MultiFactor Authentication
Is there a way to use Google Authenticator with smart sheets as a 2 factor authentication method? Thanks!
Gantt Chart + Start/Finish Columns
I have a need to combine the detail of the start/finish date from the grid view with the visualization of the Gantt chart view. Is this possible?
Can't add new receiver (To:) to recurring attachment per email
I have a report I've built that is send as attachment to the management team weekly using the "Send as Attachment > Delivery: Schedule to send on a recurring basis feature." Now, I would like to add a new Manager to the receivers list. When I navigate to the message at "Sent to > Edit Recurrence" I can change delivery…
Copy date field into text/number field
I have a summary at the top of my project plan that has, as a part of it, phase 1, phase 2 and phase 3 go-livedates. I would like those dates to update automatically when the start date of the go-live changes. I've tried a simple =cellname1 but I get a #numberexpected error. Do I need to convert it into something first?
MS Project 2016
Hi All, I've just updated to MS Project 2016 and am unable to import my programmes into Smartsheet. The tasks import ok, but the duration of every task is at zero days. Urgent advice would be greatly appreciated please. Alan
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…
Half Day - Vacation Days?
hi, I am using the smartsheet vaction tracker as well. Has anyone figured out how to track half days? thanks in advance.