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 March 2016
Discussion List
Instant Notification Whenever Someone Assigned?
Is there a way to make it so whenever someone is chosen in a contact list, they receive a notification that they've been "assigned"? I see that folks can receive an alert if anything changes, but I only want them to receive a notification if they're chosen. Thanks!
Can I use Find in a count formula?
I have a spreadsheet that is a calendar for consultants. I have the primary column using the consultants name as the Grandparent, the Month as the Parent and the weeks of the month as the children. * Consultant * Month * Week * I have another column that shows availability using RYGG for different status'. * What I want to…
Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
Calculate the MEDIAN and MODE from a list of numbers
Hi there Does anyone know the formula to caluculate the following (based on a list of numbers within a cell range)? MEDIAN - The middle number when the numbers are put in order MODE - Most frequently occuring number Thanks in advance Phil
Alstom Legacy Team Members
Our team has several Alstom Legacy team members. Does anyone know of any issues with Alstom users (Alstom email address) accessing & editing shared sheets?
Integration with Infusionsoft
I see there is an integration for Salesforce, but is there currently or plans in the future to build an integration with Infusionsoft? Infusionsoft is a tool that all small businesses are or should be using to automate their sales and marketing. It would make sense that smartsheet would integrate with Infusionsoft.
Notification Sent to Assigned Contact 4 Weeks Out...
Hi there, We run about 200 events per year and need to inform our trainers that they're assigned 4 weeks before the event start date. I know I can use the Reminder feature to send a reminder up to 2 weeks out, but that's not enough lead time. The master sheet we use is initially populated as an "Event Request" using a…
web form for order form
I'm new to Smartsheet. Have created a sheet with a web form to be an order form for our customers. In part of the form I'm wanting to provide our customers with the functionality of entering quantities for our various products, how do I do that? Thanks :)
Automatic formula fill
It says in the smartsheet help files that inserted blank rows should automatically fill formulas if the new row is between two contiguous formulas... For most of my sheet this is true. However, I have one very long formula that identifies a month based on the date and it seems to stump the autofill. Is this intentional or…
Super cool! Box integration and email upload
We use Box.com to store and collaborate on files with both internal and external colleagues. If you do too, here are two cool features you may not know about. 1) You can "attach" files stored on Box to your SmartSheet row. When a user clicks on the link to open the file, a new browser window opens inside of which Box opens…