-
Lock the columns for everyone other than Smartsheet admins.
I want to lock the smartsheet columns for everyone to avoid the shuffling the column every now and then. And users who have access to the sheet, they can only edit the details but should not be able to shuffle the columns. Is it possible to achieve?
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
-
Random Number
How is it possible that there isn't a RANDOM() function in Smartsheets to generate a random number of a specified number of digits!? Am I just missing something? Anyone have any clever workaround? Just need a random number to start with that I can do further manipulation with...
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…
-
Create way to reflect quarter?
Dear brains, I have the following setup that I need some suggestions on: I have a database that captures planned travel across the year, and is captured just before every quarter for the upcoming quarter plus one month (so for example, the db will be populated in September for Q2 travel from October - January, but January…
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
Nested ranges in INDEX/COLLECT??
I need to pull in all of the email addresses from a sheet into another sheet so that my workflow can alert the people listed in that cell. I have the cell set up as a contact list allowing multiple contacts. I need to pull all the emails for "Anywhere US" where the level is "Major" into the sheet that has my workflow when…
-
Update Template
I would like to see an option to edit/update a template without using the template to create a sheet, editing the sheet, and saving as a new template. The current process creates additional templates that might have to be renamed and then removed. If we could edit the template itself, it would make the process much easier…
-
Why are columns not printing in the width that I've set them on the report?
We have a lot of people complaining about the size of the reports when they print. We would like the content on one page, and when we shrink the column width in the report it still stretches out when printed making the font very small. Is there a way to maximize the page similar to excel when you pick the "fit columns on…
