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 December 2016
Discussion List
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?
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…
Multi Project Milestone Report
I have a series of projects that I need to report out the End Date for each of the milestones and I'd like to do that in a table. So here is what I have. I have 7 projects, each with 7 Milestones, each with 1 dates. I laid those out in a report as 3 separate columns - Project, Milestone, Date. So what I need a table with…
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
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…
Limited acces to a sheet
dears, we manage all our shipments of our customer in several datasheets. For some milestones we need a third party update some cells in a report. we though do not want them to see all the data of which part is confidential. Is that possible. In essence, give someone the ability to update a report without giving him/her…
Managing large number of filters
I manage product releases and have multiple columns that I need to filter by (department and owner). I have a variety of entries in a given column, but I cannot find a way to click the dropdown at the top of the column and select one of the values within that column (like how filter works in Excel). Am I forced to create a…
Streching Rows
Hi there everyone Is there a way on streching rows for more space? I will like to add some space to some rows. can someome give me some lite with this? Thanks
