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 2017 Posts
Archives for July 2017
Discussion List
uploading images to forms
we have put together a web form to collect some QA data from field. Each entry contains an image. Several users have complained that when they press submit, it keeps spinning and does not move forward. Our users are using IPhone/Ipad and image size per entry can be between 2-3MB. How can we make user experience better ? Is…
Resources and Vacations
Is there a way to easily add Resources (who are not Users within the plan) and add their vacation dates so that when a task is allocated to them in a Gantt sheet these vacation days are taken into account as non-working days? I've tried using the Team Vacation Schedule (as…
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up. We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it…
Task Name data not available from SSIS odbc connection
I have developed an SSIS package to read Smartsheet data, and then export the data into SQL database. I managed to export the data but noticed the Task Name, % Complete, Status fields are returning NULL values. This doesn't make sense because these fields are populated with data on Smartsheet. Please assist.
CheckList items not present from Trello import
I imported a board from Trello, where I used CheckList on a lot of cards. It now looks as though the items on the CheckLists didn't follow the import, just the number of items and how many are completed. Can I find those items anywhere or are they not here?
Outage?
Is there some kind of outage with SmartSheet? My files have errors and won't print to pdf!
Formula to display when a task is late based on start date and status/% complete
I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete. I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns. Thanks in advance community!
SmarSheet Expiring for shared user and requiring subscription
Team! One of my clients is reluctant to use SmartSheets because she claims that when I share access and a certain amount of time has passed that she is required to purchase a subscription to SmartSheets. Is this true? I cannot find any documentation that supports this. Thanks.
Report - shows only parent projects (or tasks)
Hello everyone, So far, I'm pleased with an interaction in this community - I get responses quickly. I really appreciate! In reporting, I'd like to show only parent projects (or parent tasks), not showing sub items. How do I select parents? Thank you! Yoko
Taking three customized smartsheets and putting them into a new Project sheet
We have three smartsheets that are all unique, but need to combine them into one Project sheet. They're medium size, so copying and pasting might work, but wouldn't that require all formats to be the same? That would take a fair amount of effort to do. I suppose I could export them all and then manually set them up in the…