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 August 2016
Discussion List
dates changed in bulk
One of my editors mistakenly indented more lines that they intended to, but when i moved them back out all the dates changed. I have corrected each one using the cell history, but without understanding how it happened in the first place. Help!
Shared document with only certain colunn
Hi, I have a question, can we share the document with users that they only can see & edit certain columns info? Cheers Quece
Formula for when if a checkbox is checked...or not
What would be the formula that would return "True" if a checkbox is marcked as checked and "False" if it is not? Thank you!
Collaborators can't access the project sheet
Hello, I'm new to the application. I've created a list of collaborators and sent out invitations. A couple of them have recieved the invites but don't have access to the project sheet when they accept and log in. This has not been the case for everyone. Any troubleshooting recommendations? Thanks, Ryan
Report error with RYGG Ball column
Hello! I have a report pulling from eight different sheets, and there is one line that is appearing that does not match the report criteria. It has been this way for weeks; I assumed there was a glitch in the system that would be worked out. The criteria is as follows: - "Status" column (RYGG Ball) is blank AND - "Dueā¦
Mail Merge Multiple Rows of Data
The task that I am trying to accomplish, is to complete a complicated mail merge for mass email. The mail merge function in MS Word or Google Docs sends out emails based on each row in your excel data sheet. Each row equals 1 email to 1 recipient. The issue is that multiple rows of data have to be sent to 1 recipient. If Iā¦
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show aā¦
Contact Database
Hello! I'm new to smartsheet.Ā I was wondering if there was a way to click on a company name and have it display all of the contacts associated with that company? I understand that you can link cells and link sheets but I don't want to create a sheet for each company. We have hundreds of companies and hundred of contactā¦
Attachment previews
I am wondering if there is any plan to add attachment previews as an option so that users have the ability to download just the document they may need from among others.Ā
Calculate a whole number with a remainder
Hey All, I have a column that calculates the time a vehicle is in our fleet. It returns a whole number such as 500 days. Is there a formula that will convert that to number of years with a remainder being the number of days. (1 year 135 days). Any help is much appreciated. Thanks Dwayne