-
Dynamic Dropdowns
I've been able to create and update 1500 dropdowns within seconds. I know a big issue in this community is wishing their is some way to update dropdown selections, with a small tweak to my javascript, options array may not contain null elements. FIX: const options = rows.map(x => x.cells.length && x.cells[0].displayValue)…
-
Auto Add/Subtract to Inventory
I am attempting to create an inventory sheet for my business and was wondering if there is a function to automatically add and subtract to a number in a cell. Maybe something similar to say a button that +1 or -1 when clicked. If this is not available what would be the best way for my staff and I to updated inventory…
-
First Entry Flag equation as column formula?
Good morning! I'm trying to create a flag in my form receiver sheet to identify first entries vs. duplicates. This is to help me pull some metrics (counts) in other sheets. I have an equation that works row by row, but not in the very first row and also can't be converted to a column formula. What am I doing wrong? I'd…
-
Numbering Duplicates Based on a Date
Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1. Currently the Revision Number formula is: =IF(ISBLANK([Service + Contractor]@row), "", MATCH([Row ID]@row,…
-
Restricted Dropdown - Find cells that don't comply
Hello All I am loving this community, it has helped me develop my sheets... so Thank you. This is my first discussion because I can't seem to find answer anywhere: I have sheet's with multiple dropdown columns on sheet that have restricted values. All these sheets feed other sheets with formulas so it is important to have…
-
Limit increase: 100,000 inbound cell links for sheets
Hi Community, Say goodbye to a limit of 20,000 inbound cell links in sheets — now, all users on all plans can add up to 100,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Stay tuned for more news about how Smartsheet is investing in scale and reliability.…
-
Merged: Unhiding Individual Columns
This discussion has been merged.
-
Prevent sheet from trying to display all proofs on opening or after saving
We have a Smartsheet that tracks the illustrations for an educational program, and it now has close to 1,000 rows, one for each illustration, each with a proof. For some reason the sheet sometimes will try to open with the right-hand proof pane set to "all" instead of "row," and when it does, the whole screen locks up with…
-
Limiting Search Bar Options
Hello, As procedures are developed into Smartsheet's user interface, a lot of "inflation" within the search bar results keep growing as well. Being able to select a default workspace or folder to start the search would be very beneficial by keeping the company moving in the direction they need to go instead of looking at…
-
Limiting Search Bar Options
Hello, As procedures are developed into Smartsheet's user interface, a lot of "inflation" within the search bar results keep growing as well. Being able to select a default workspace or folder to start the search would be very beneficial by keeping the company moving in the direction they need to go instead of looking at…