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.
Discussion List
Using Zapier to Move Attachments and Comments
Is there any way to have Zapier move an entire Sheet's contents? I am trying to automatically move selected contents of a row that contains confidential information to another sheet that can be viewed by a user who I don't want to access that confidential information. But I also want them to be able to comment on the…
Using Reports to Isolate User Access
I need to manage information pertaining to a client (single row per client) that contains three different types of information used by three different users. The sheet has formula that I want to continue down the sheet automatically. Because we are using webforms to register new client information, every time a user goes…
Automated task status in a project plan
I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task. I've tried several of the IF OR and IFAND statements and they work partly. I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress". When I try to nest…
Creating user Dashboards as Sights - filtering
I am creating sights for team members on my projects so that they can see their assigned tasks all in one place - no doubt a common use for Sights. Anyway, when I link multiple sheets into a report and expose the sheet name, when the user clicks on that link, they are taken to the sheet and not the row. Is there any way to…
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…
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…
How to use if cycle ... getting #INVALID OPERATION message
Hi, I'm trying to use a formula: if workcomplete is less then 100% then look for "process engineer" where Health matches "On Time", so formula would be the following: =IF(([% Work Complete]4:[% Work Complete]245 < 1), LOOKUP(Health4:Health245, "Process Engineering", Health4:Health245, "On Time")) I keep getting #INVALID…
LastChild() function?
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
Contact list and webforms
Hi, I have a column on my sheet which is the contact list. However, in the webform it does not show as a contact list. So I had to go and make it a dropdown with the exact same options as the contact list. Now, these sheet line items are not pulling through on my various reports. Because in the report builder I must now…
Feature Request - Mobile - Send Rows via E-mail (or Send Update)
I was wondering if there is something in the pipeline already for adding the Send or Send Update Request via the mobile app. This would help with our mobile team for providing or asking for updates from colleagues. Or if someone is already aware of a way of doing it. Thanks
