-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Matrix Sheet based on date and personal resource assigned
Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix style sheet. This matrix style sheet will pull data from several other databases within smartsheets. The matrix should…
-
Merged: Capability to add more than one column at a time
This discussion has been merged.
-
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.
-
Formula for identifying schedule conflicts with multiple assigned people
I have been trying with no success to create a formula to identify schedule conflicts if multiple people are assigned. The formula works fine with a single person assigned. For the test case, I am using a separate table (on the left) to identify when people will not be available. The right side is representative of typical…
-
Less round and less cartooney fonts and icons would be easier to rapidly scan and ingest
I see the aesthetics of the new, rounder and softer-edge fonts and icons in the menus, but from a user access and efficiency standpoint, do not like them. I want to be able to scan the sheets in my workspace quickly, and rapidly jump between sheets, and these new fonts and design elements are harder to read at a glance.…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
-
"Use template" - can do 1 at a time and save in a folder, is there ability to do more than 1
We are setting up master templates that we want to use for a customer project. We currently can select to use 1 template and place it in the customer folder. Is there a way to select multiple templates an send them to the customer folder at the same time?
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…