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 February 2016
Discussion List
Refreshing reports
How to refresh 5 reports (with each assigned person's tasks) at one time when the main spreadsheet is updated instead of going into each report separately to refresh? Or will the reports update automatically when there is a change to the main spreadsheet.
Import calendar into Lotus Notes
My organization uses Lotus Notes and I need to be able to sync the Lotus Notes calendar with smart sheet but have not been able to find any information on how to do that.
NEW - Dashboard + Card layout
Is Smartsheet getting ready to release the new dashboard and card layout/view? Looks like they are close. There are a few screenshots within the video and webpage. https://www.facebook.com/smartsheet/videos/10153492657651379/ https://www.smartsheet.com/enterprise/scale These look amazing but I still cannot wait to get…
Custom print sizes
Is there any way to print to a custom pdf size? Or if custom isn't available A5?
Conditional Formatting/Notifications
I have encountered a question from my team, and was wondering if there is a solution. They were curious if you can set up notifications, or something else (like conditional formatting), to where you would be notified that if a check box was checked in a certain cell, and then a file was uploaded to the line with that cell,…
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
Average % complete if task is assigned to "xxx"
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned…
Column headers not available to select from Excel import
I have imported many Excel files to Smartsheet. however, I cannot figure out why I cannot select the column headers from my Excel file as the column headers in Smartsheet. I've tried changing thigns in Excel in attempt to support the import: * cell type from "general" to "text * removing filter option * removing and adding…
REFERENCIA: Time Tracker for Client Projects with Form AND =SUM(CHILDREN())
cuando modifico esta plantilla usando insertando lineas arriba o hacia abajo, las letras resultan de color rojo, al respecto , que debo hacer para solucionar este inconveniente. gracias espero tu respuesta
Applying formula/conditional formatting to an entire column + hiding the column
Hi all, I am using the LEN formula in one column ("EN title character count") to show the number of characters in another (column "EN title") then applying conditional formatting to this column ("EN title") to show as bolded and red when the character count is greater than 80. This works perfectly, but I'd like to be able…