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 June 2016
Discussion List
deleted rows - is there way to find out who
How can we tell who deleted a row in a sheet?
Advice for creating Summary Sheet/Report/Sight
I have become fairly comfortable with Smartsheet, but need a solution that I could use some help on. I have Project sheets and reports for teams and users that use the Status field for counts. I want to create a sheet/report/sight that shows the status for all projects assigned to a team and each user. Hopefully this image…
Complaint / Poor Design: Blank Reports
I've just learned reports shared with users who are not also shared to the sheet (or sheets) that contain the base data cannot see the reports due to "security issues". This is - in my opinion - a seriously poor design. If Smartsheet can't secure a sheet / report relationship in this manner, what's to say anything can be…
Tracking Meetings In Smartsheet
I'm trying to figure out the best way to make meeting agendas, minutes and action items available to the team using Smartsheets (not necessarily *a* Smartsheet). Our group has daily stand-ups, weekly status, and other meetings, most of which will require an agenda, and any of which can produce an action item list. It's not…
Referencing External Sheet Data
Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. Is it possible to type in an asset tag and have the corresponding serial number auto-fill in the adjacent column? Thanks!
Date Format yyyy-mm-dd
Hi all. I've found the numerous help articles describing the Date Format being controlled by your \Account\Personal Settings\Language (Country)\ selection, but as far as I can tell all formats are mm/dd/yy or dd/mm/yy. I need to format in the ISO standard of yyyy-mm-dd. Has anybody successfully found a way or implemented a…
Updating a reports format from the related smartsheets
I have a report that looks at 30 smartsheets for current task status. On each smartsheet I have conditional formating to change the complete lines color based on a date field and the current date. When I run the report and I know a line should have chane color but hasn't, I open the related smartsheet and the line color…
Add pictures to a web form
Hello, is it somehow possible to add an image to a web form? I would like to have an image with a selection field next to it (so a user can visually see an example of a product they are selecting). Any way to do this? Thanks!
Managing dropdown list selections from another sheet
Hi all... My company has an ever-evolving list of clients. I'm looking to utilize a dropdown list for users to select the client instead of asking them to type it in (eliminate keystroke errors and inconsistent naming). Being the client list is frequently updated, is it possible to manage this through a separate "linked"…
Sending a row default layout
Hello, It seems the default layout is set to vertical but we prefer the horizontal layout. Is there a way to change this setup once and keep it for all future communications? Thanks,