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
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
Calendar sync
Can I sync the calendar with my Google calendar so only tasks related to myself show up?
Universal Date Setting for Date fields
Can a Universal Date Setting be added to Smartsheet settings please?
Formula to return Parent name of child?
I'm trying to figure out how to return the name of a child's Parent. Example: Parent 1 * Child 1 * Child 2 * Child 3 Parent 2 * Child 4 * Child 5 In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function…
Is there a way to tie a web form to a specific record?
I have a SmartSheet where the user enters the preliminary information via a webform, which assignes an autonumber to that record. I would like them to be able to update that record via a webform without me having to send an update request. Is there any way to create a webform where the user enters the item number and it…
Reports / Master Calendar
Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job. I know there currently isn't anyway to put 2 people on the same job and that I would…
Multiple projects on one sheet
We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if…
Time Specific Tasks
Hi I have a project where the time for each task is key during a few days of it. i.e. a task is due to start at 10.00 and continue to 13.00. I may have missed something, but is there a way of creating this rather than just date specific? Thanks Nick
Convert text to number
Hi is there a way to convert a text to a number like: "One" to 1. VALUE() doesn't work. Thanks Peter
Recurring BackUp for Workspaces
Hiya, Is there an option to set a recurring backup for Workspaces. Due to a large number of 'loose' sheets I am creating workspaces, however I now have to click on each individual sheet to request a backup. Is this something that can be resolved, or looked into as this is far too time consuming - the recurring backup…