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 May 2016
Discussion List
Primary Rows
How do I create a new primary row in SS? One that carries sub heads and rolls up to the calendar?
Keyboard shortcut request, hyperlinks and open discussion
I've had some trouble getting hyperlinks to import/export, and I have alot of rows that I have to perform manual operations on in bulk. i also have some nifty tricks with AutoHotKey as long as operations can be completed using keystrokes. Can we please add keyboard shortcuts for adding hyperlinks and opening the discussion
Sorting
My reports are very slow to recognize changes and sort properly since the update. Nearly 30 min for one report to register date changes and sort them properly.
Conditional Formatting Question
We use a Project Timeline Template that tracks the progress of each individual project. There are a number of parent rows with child rows beneath. I've created a status column so that each task can reflect the current progress via a harvey ball. I would like the parent rows to reflect the overall current status based onā¦
New features with Zapier
All, Check out the new features from yesterday's update. https://www.smartsheet.com/release-notes Smartsheet will be pushing the Sight updates. I'm most enthused about the Zapier updates: 5. Smartsheet for Zapier Enhancements Significant enhancements to Smartsheet for Zapier add a number of new triggers and actions:ā¦
Command + L on Mac - Is it working?
I am working on formalas in Smartsheet using a Mac. From my understanding, clicking Command + L is supposed to convert a relative reference to an absolute reference by automatically inserting the "$" in front of the column and row of a formula, but it does nothing. However, if I go to my browser and click Command + L allā¦
Quote Sheet
Im trying to develop a sheet for a Quote Estimate to Customer with customer details auto added from contact sheet?
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the statusā¦
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
Excel formula not working in Smartsheet
I would like to get the equivalent of the below formula working in my smartsheet. It is currently erroring: =IF(L7="Not Applicable",K7,(IF(OR(ISBLANK(K7),ISBLANK(L7)),"Pending",IF(K7>L7,K7,L7))))