How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the proper…
Finding the maximum value over a range is a simple matter given Smartsheets formula. How does one filter the data in the range? That is, find the maximum value of the data in a column given, in my cas…
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignme…
How do you make a link in a template? I am designing a system that uses a to-do list for each new transaction - the blank to-do list is stored as a template. There are three columns on the template. 1…
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible. I see where I can use test the value of a ch…
One of the features we really liked before was the ability to collapse message threads based upon certain topics. This new version of discussion threads doesn’t appear to allow for that. Is there any …
I've created a set of templates which are essentially extended to-do lists for tracking real estate escrows. Each new escrow gets a fresh sheet inserted into the <active escrow> work group. The user i…
I have a sheet that serves as a team pipeline report and I would like to have a weekly update request where every row assigned to a specifc person is included automatically in the request. Each row ha…
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at …
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of…