-
Copy row with no hierarchy on one sheet and make it a child on another.
I have a been working on building a asset inspection tracking workspace. I currently have 4 sheets built for it. The first, Asset Master List, has all of the assets and information about the asset built into it. This sheet was built from an Excel Import. The second sheet, Inspection Form, has all of the form responses for…
-
Shouldn't predecessors and dependencies work differently?
This is not just with Smartsheet, but any project planning software I've seen so far. Dependencies have four types, and this is how they work: Finish-to-Start (FS): The "normal" type of dependency. This sets the start date equal to the day after the finish date of the predecessor. You can adjust the duration or finish…
-
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…
