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
Getting rid of recurring dialog box
How can I permanently get rid of the dialog box that pops up every time I go to a report page reminding me that "Your report is read-only until you upgrade to a plan that includes reports."? It's very annoying.
Changing "Primary" note on Sight
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
Encoding for importing csv file
Hello My csv file to import contacts has accented characters and these ones are not recognized (or badly converted) when importing. I tried my file with UTF-8, UTF-8-without BOM and ANSI encoding and same result for all 3. Does anyone solved this kind of issue? If i use the same file to import new user, accented characters…
Date Formula to exclude weekends
Hi Friends, I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday. I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday. Hope this make sense?
Assessments
Can Smartsheets be used to provide assessments of businesses? If so, are there any recommended templates that could be used to accomplish this mission?
Interested to hear from people who have/plan to use Smartsheet as a Facilities/Maintenance System
Hello all, I have been using Smartsheet to help my clients digitise their Cleaning / Maintenance / Landscaping / Service processes and businesses. This includes Site/Location/Asset lists, service request and reactive/planned work tickets. I have created a solution that allows Services Requests come in via forms, get…
Confluence Documents
Smartsheets has an API to work with JIRA, which is an Atlassian product. Conflulence is Atlassian's collaboration tool. Is there a way to link/attach Confluence documents too? - Jeff
New Filtering and Filter sets
Hi All, I appreciate the new Filtering functionality to make and share filter sets with users, great idea. I have a refinement to suggest. Can I ask to have a filter condition included to equate the value to a maximum or minimum value of the field? is same as Maximum is same as Minimum This way when a maximum or minimum…
How do I remove the Share property to a Sheet that I've saved as a back up?
How can remove all references to a sheet? Here's a summary of what I've tried. * Sheet A is my Master on which I have many project tasks out to various resources. * I made a backup of Sheet A and called it Sheet B. * I then deleted a lot of tasks from Sheet A knowing that I had them saved in Sheet B. * I removed sharing on…
