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 May 2017
Discussion List
More robust calendar
Will there ever a be a proper calendar in Smartsheet? For example, an actual calendar and not just a spreadsheet with a calendar view that shows only one line (the primary column name). Would be nice to display times on the calendar and more fields, not just the primary column name.
Formulas- Pulling dollar values from text string
Hello, I'am new to Smartsheets and trying to pull a dollar value out of a text string to put in an adjacent column. ACI - A/CP-BP 10k Type 2 Bullet Probe | 24" Leads $6.02
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
Progress Bar Automation, based on % Complete IF/THEN
I conducted a search but could not find this specific topic, so please forgive if I am repeating an existing question. Hopefully the subject line is incrementally more search optimized. BACKGROUND I am using IF/THEN formulas in my '% Complete' column to auto-populate a Progress Bar that goes into my status reports as a…
Display of a formula under/above row
Hello In some sheets i have long formulas to grab many intermediate values and eg. sum them in one cell. Problem is when I need to click a cell and this is hidden by formula. Can the formula be displayed under/above a row where I'm typing?
Looking for a way to associate a checkbox in one field with content in another.
I am creating a log of all new, won opportunities. The goal is to catalog the types of services included in each new opportunity. Next, we need to understand the revenue split by service types. I created a web form that allows users to "check" the service types in the opportunity. Next, I need them to allocate the revenue…
The option to change parent row calendar colors when dependencies are enabled
I have several tasks in each of my sheets that I want to see in a report for major milestones. I want the different tasks to have different colors. Right now it is possible to change the color of children rows on the Gantt Chart/Calendar view, however when dependencies are enable, it's not possible to change the color of…
Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
Python API error "SSL handshake error, old CA bundle or old OpenSSL"
I'm using Mac Sierra and i'm trying a simple test: import smartsheet smartsheet = smartsheet.Smartsheet('mytoken') me = smartsheet.Users.get_current_user() print(me) And i'm getting an error: smartsheet.exceptions.HttpError: (SSLError(SSLError(SSLError(1, u'[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure…
Primary column not sorting properly
My primary column contains numbers (1 to 250 and growing). When I sort I get the 200's first going up then the 100's. They are numbers as near as I can tell and not text. If I use the add/remove decimal places tool they respond properly? What am I overlooking?