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 November 2017
Discussion List
Just want the checkbox to check if the date is past due
Hi All, I've got a basic spreadsheet that I need the have the "complete" box automatically check itself if the due date is 1 day past due. I know I can do this with an =IF formula, I just can't figure out how. Can someone help? Best!
Can I attach a document as help text in a webform?
Hi there, I need to include a budget template in a webform I created. My initial thought was to embed a link to the template, but it does not appear to be possible to put a hyperlink in a Smartsheet webform. Can I attach a word doc/excel spreadsheet to the webform help text somehow? Best, Molly
Confused by users and resources
I'm pretty new to SS, which I've been added to by my project's owner as their preferred tool. We have set up a high-level schedule with gantt chart to get a top-level idea on estimates. I've assigned tasks to people (adding them as needed) and got a pretty gantt with a critical path, but have no idea how utilised each…
Box.com Integration
This is an idea for an improvement to the box.com integration. Ideally, SmartSheet would allow attaching a document from my desktop directly to a row in SmartSheet while storing the document in Box.com. For example: 1. Drag and drop a document to a SmartSheet row / attachment. 2. Automatically create a folder in box.com…
Sending Update Request
Hi, Is there a way to select more than 1 row when sending update requests? For example, I have a teacher that tutors 3 classrooms. When I filter for those students, I get 100 rows. Is there a faster way to select all of the rows for updating or do I have to select one at a time? Thank you. PM at a Virtual Charter School
Remove user from shared worksheets
Several worksheets were shared to a specific user (email) but is not part of our user list found on the user management page. Is there a way to update this by bulk and not going through each worksheet? Unfortunately, some sheets were outside of a workspace. Thanks.
Usability of contact information
Does anyone know a way of using the contact information when a new contact name is up-loaded into the sheets? I specifically refer to the e-mail address, as i'm unable to copy and paste into an e-mail from that tab. To date i have just been using a separate column for e-mail addresses, but this seems to be doubling up on…
If "x", and checked box y
Hello, I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked I've tried the following equasions =IF(AND(Team7 = "Street Lighting", (NOT(ISBLANK([Quote…
Backups and Backup size
Hi, Any advice on how you guys save your backups to reduce the size it takes on your servers? Y
Live Data Connector on MAC OS
I want to connect my Tableau Studio to smartsheet via the Live Data Connector. As far as i can see there is only an ODBC connector for Windows available. Am I able to setup the Live Data Connector on MAC OS? Toon