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.
Discussion List
Versioning
I want to create a sheet to hold documents and track versions as they are edited by members of a group, any ideas
Search Function for Report Rows
Is there a way to allow the search function to search reports? I have used the search function from a report and search returns only rows from the controlling sheet. The report is used to give a user access to just the information they need to see/edit. The user getting sent to the originating sheet only makes it difficult…
Generate Report per Row
Is there a way to generate a report per row? I have one project for each row with numerous columns. I would like to create a one page report that list the columns in a vertical format with the data from its corresponding row. Does that make sense?
How do I autofill a formula to new rows that will be added via a web form?
Hi, I'm trying to have a formula autofill as new rows are entered into a project list sheet. I know smartsheet has an autofill formula feature, but I'm not sure how to use it. Is it an automatic thing by default, because if that's so, my formulas from the rows above are not autofilling in new rows created. Any help…
Weighted Percentage for Parent Rows
Instead of an even roll-up - can the parent percentage be set to a specific value relative to the project - see my example below; 1. (Project) Big Steel Project - 100% 2. (Parant)Steel Box - 50% 3. (Child) Bottom 70% 4. (Child) Sides 30% 5. (Parant)Steel Post - 30% 6. (Child)Short Posts 20% 7. (Child)Long Posts 80% 8.…
Update Requests (Templates - multiple cc's?)
I have a standard request that gets sent to different people to update a row or rows. There may be more than one person responsible for the updating. I tried sending the request to 3 people but only the first gets the "open form" button. Also, I want to CC their supervisors instead of just me. Is there a way to create a…
Show tasks in Ressource View
In the Ressource View one can see allocations across sheets and one can click the little triangle beside each User to see allocations on each sheet. It would be a BIG improvement if one could fold down each sheet as well to see task allocations. So on the above I could see the tasks on Project Sheet A that Sally Smart was…
Manage project by workload instead of duration
Hello all, in our company we used to work by workload instead of duration / capacity. This is really important for us as we're a consultancy company and selling man days and not duration. What is the best way to work like that ? For the moment the workaround is: - I use is to put a duration then calculate the allocation %…
Google Calendar
Hi everyone, I am trying to sync my smart sheet with my google calendar, but it appears that only the "Task Name" column comes over. Do you know of anyway to get a column to sync with the Address or Description fields in calendar events? Thanks!
Widget Display Order
Is there a way to set the display order of widgets when viewing via a mobile device? When devloping sights what looks good on a desktop quite often displays out of order on mobile screeens of a different aspet ratio.
