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
LOOKUP documentation mismatch
The formula documentation: http://help.smartsheet.com/articles/775363-using-formulas gives these as the arguments: LOOKUP(value, collection, return_column_index, collection_match) while the Template for Formula examples gives these arguments: LOOKUP(lookup_value, lookup_range, return_column_index, range_lookup) The fourth…
sharing
I have a form on our website for people to enter info. I have a email from Smartsheet with a request from someone using the form to have me share the sheet with them. How does this happen? Skip
Moving to Salesforce Lightning - no support for Smartsheet Integration?
Hi all, We are moving Salesforce from classic to Ligtning and discovered that the Salesforce integration (NOT the new connector) is not supported. So we can no longer link Smartsheets to our accounts or records. Have I read the material wrong or has anyone had experience with Lightning and found a way to make this work.…
SUMIF Circular Reference
I have a time/hours sheet to keep track of customers that have varying statuses. The statuses include in progress, complete, and cancelled. I currently have the sheet being sorted based on the status so that It has a title row showing the total numbers for each status below it. As a status changes from in progress to…
Printing Sight View
Is it possible to print a Sight view? I spent a long time setting up an attractive Sight pulling from a report and other data and now want to be able to print it. What are my options? By publishing it to a URL, will I be able to print the URL view? Thank you for any feedback!
Reporting When a Sheet was Last Updated
As we struggle with user adoption we are trying to find a way to understand who is and who is not updating their sheets within SmartSheet. I have tried a variety of user reports and system reports, but not seeing a lot that can help with this. At the end of the day we are just trying to see that a sheet had an update done…
Print resource view
Can you print resource views?
Auto-populate %complete based on dates / duration
Hi, All my project sheets are all set up with project, status, start date, end date, duration, %complete and predecessors. I also have a checkbox column to mark when a task is complete. I'd like to format my % complete column so that it auto-calculates how much of a task has been done based on the start and end dates. I'd…
Show Attachments of Folders
We like to see the attachments of a folder directly beside the sheets of the folder. I marked this in red in the screenshot. We think this would make it easier to find the attachments. Possible?
Conditional Operations on Read Only Fields when Record is Modified
Scenario Two Fields Responsible Date Closed (read only) Requirements 1) When the record is updated, if Responsible equals "Closed", automatically populate Date Closed with TODAY() 2) When the record is updated, if Responsible does not equal "Closed", automatically populate Date Closed with blank What tools/methods can be…
