-
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…
-
Linking two sheets in a workflow
Hello, I work for a healthcare system on our capital project team. We have a smartsheet form that we use to initiate a PO request. We also have a form where if equipment is changed on a project, we have documentation as to why the equipment change is needed. I am wanting to link these two sheets together. Example: if we…
-
Editing outside of pro plan
I am confused as to why a user is restricted to editing on a pro plan ONLY when they have a license on the same plan. This seems counter-productive and restricts someone to only collaborating with one entity. For example, I want to grant access to edit within my sheet to another user who is part of an organization with…