-
Multiple Line Entries with one Form Submission
It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team. As of now, form entries can only create singular row entries on sheets.
-
Remove all hierarchy (indents) from a sheet
Hi, I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it. My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore I planned to create a new sheet where I removed all the hierarchy/indents (sort of…
-
Hide Blank Columns in "Print" view
Smartsheet already gives the ability to display hidden columns when printing, but it'd be REALLY nice if you could hide columns that don't have data in them. If you have a huge form (50+ columns) with a bunch of conditional logic, there's going to be a lot of blank columns in any of the sheet views currently available.…
-
Smartsheet Template for ADDIE Model of ID
Has anyone created a Smartsheet template that follows the ADDIE (Analysis, Design, Development, Implementation, Evaluation) model of instructional design? I'm looking to use Smartsheet to manage our ID process, which is based on that model. Thanks!
-
Auto-Sorting sheet hacks
Hey guys! I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting? I…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
-
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…
-
CountIfs Function to Determine if Completed on Time
Hi, I am trying to put together a formula sheet from our data in our inventory. Within the inventory, each project is assigned to someone and given a due date, they will manually enter their completion date. I want the formula to count # of projects someone completes on time. Here is my current formula: =COUNTIFS({Assigned…
-
Request Access Notification
I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving access requests for projects almost hourly. Unfortunately, the way we have our project…