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
Formula to calculate the last update of a specific column
Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.
I want to share an editable report but not the underlying data
Hello, I have share a report with my team, in the underlying data they have view only rights and in the report they have editor rights. Unfortunately, the rights from the underlying data appear to be taking precedent. I have tried moving the report so it is no longer in the same workspace but the editor still only have…
The collasp and expand thing is really driving me CRAZY
Please help get this fixed! I am the only one looking at these sheets so I know it's not because of someone else doing it while I'm looking at it. Like others my sheets are very long even when things are collasped, so when they are all expanded and for some reason it defaults to the top of the sheet, it is taking a lot of…
Batch process for moving cell contents to Comments?
Hi community We just took a large Excel project sheet into SS. In the old, sheet users were just adding freeform Notes to a column called "Notes" I would simply like to migrate the content of each cell in the "Notes" column, to the Comments field in the new SS ... however with 800 rows to deal with that's a lot of…
Move/import comments
I have comments on a sheet that is no longer going to fit with our structure and I would like to move the comments from a row on one sheet to a row on another sheet. Is there any way to move comments from one row to another? Any way to import comments to an existing sheet? I exported the sheet to Excel and the comments are…
Sort Children without affecting Parent Row
Hi everyone Happy Friday-eve! Is there a way to 'sort' Chidren only. I have a small but important Inventory list - Parent Row reflects Brand - Children reflect actual equipment. I then also have GTrandchildren to show when Children (equipment) have been out on loan and have returned and the current status. I'd like to sort…
Multiple options in a dropdown list
I am creating a web form and I've created a dropdown list. I want the end user to be able to choose multiple options if needed, but the dropdown list won't allow that. How can I make that work? Or what is the other suggested format?
Settings for Checkbox Column
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
Column Tooltips
I am looking for a way to have tooltips on column headers in a sheet. The reason is say you have a large sheet that is being used for data collection. Some of the fields people may not understand exacly what you are looking for, so having a way to put in a tip or description would be great.
Web Forms
I currently have a web form that a user submits when they require time off. I am using a contact list for the name field. When a form is submitted I email the manager. Once she get it she either approves or not. If she approves I want an email to be automatically sent to the user. This is working but I'm afraid if the name…
