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 June 2016
Discussion List
Pie Charts in Sights
Does anyone know if you can put a pie chart into a sight? If so how?
File Upload Limit to Web Form
Hi folks We use web forms to allow employees to upload images from their mobile devices (creating a new row in a smartsheet and attaching the images.) At present we seem to be stuck at a limit of 10 images, however the attachment limit for a row appears to be much higher. Is there a way to bypass this "mobile" upload…
Row Sorting
I am trying to sort a smartsheet where I have some rows at the top that are used for calculations and formulas, so I only want to sort certain rows not all of them. Is there a way to do this? I tried locking those rows but that doesn't work, and I tried just highlighting just the rows I want sorted (similar to how it works…
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
Attachments with Update Requests
How can you send an update request for more attachments (photos) without sending the existing attachments for that row?
Adding Text Value if checkbox is checked
I have two columns - One is a checkbox, the other is a text format. I'd like to write a formula that essentially says, "If checkbox is checked (true) then populate the word "Checked" in the text cell. Else if checkbox is unchecked (false) leave text cell empty". Are there any formulas out there that can do this? Thanks, -PJ
Is it possible to default to the calendar view rather than the grid view?
I set up a conf room reservation system using a report on top of a smartsheet. I've shared the URL with end users but sometimes when they follow the link it displays in grid view when I only want it to display in calendar view. Sometimes its correct and sometimes not which is causing headaches. Is there a way to force one…
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
How to position and move rows in iPhone app?
It looks like the add row function in the iPhone app simply adds a row to the bottom of the sheet. Is there a way to position or move rows that I'm not seeing? Thanks, Chris
