Best Of
Re: Error - Formulas reference too many cells
Hi @cantpickname,
The total count of cells referenced by formulas in a sheet cannot exceed 25 million. This includes references to in-sheet cells, columns, ranges, and cross-sheet references.
To understand how this limit is calculated:
If a single cell has a formula that refers to 10 columns on a sheet with 10,000 rows, then that formula is referencing 100,000 cells (10columns x 10,000rows = 100,000cells).
However, if that formula exists in 100 different cells, then the total referred cells is 10,000,000 (100,000 referred cells * 100 formulas = 10-million)
Are any of your cross-sheet formulas VLOOKUP? If so, I would suggest replacing these with INDEX(MATCH functions instead. VLOOKUP will refer to an entire table range, while INDEX(MATCH only refers to the columns necessary to lookup and return a value.
Let me know if you need help adjusting your formulas!
Cheers,
Genevieve
Genevieve P.
Re: Update Request Customization - descriptions and headers like a Form
As with a form, it would be nice to have some type of help text the user can see when filling out the update request form. This will drastically improve the user experience and help us add value to users we ask to update data on our sheets.
Erik Hartman
Re: Contact Lists
Hi @alangham
I hope you're well and safe!
This is probably a perfect use case for the Premium App, Data Shuttle.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Chart Colors
@David Goshorn Yes, I'm afraid there are still niggly things about Charts, but like Paul has put here, you might need to submit an enhancement before they are sorted out. With the workaround from this thread in place you might find that changing the Pie Chart into a Semi circle type chart will help...drawn up a demo here to show the impact...
Hope this is useful
Kind regards
Debbie
Debbie Sawyer
Re: Unhide specific columns on a sheet
Hello,
Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't used our procedures much.
It's not a big problem if 1 person is running the show, but as soon as multiple brains get put together and want to start developing procedures within their own departments, data can be easily forgotten and duplicated.
Some sort of task manager to show a list of the columns with the ability to possibly check/uncheck the individual columns that you want to be shown would be great! It can be set up on the right side bar and operate the same as the rest, within that bar, having the window that slides out after making a selection.
Like I mentioned above, as soon as there's more than 1 person working within the same sheet, confusion can easily be caused by a mis-click and the feeling of "starting over" the task (hiding columns) comes on.
MichaelTCA
Re: Unhide specific columns on a sheet
It seems this is a perennial request. I've found comments on this issue back to 2015, at it is no better in 2023. Very clunky interface. In Excel, if I know Column H is hidden I can use GoTo to go to H1 and then Alt+Col+Unhide. There is no equivalent in Smartsheet. I'm currently working on a project where, to unhide a column just to the right of a known column, I have to drag about 8 other columns unhidden, finally revealing the column I want. Then I have to hide those 8 columns again.
Come on Smartsheet, y'all can do better.
Sequoia S.
Deleting Rows from Dynamic View
Can users (not owner or admin) have the ability to delete rows from a dynamic view?
Thanks!
courtney.jones
Re: Ignore duplicate rows in a report
You could group the report by date and then create a sub group by visitor.
Paul Newcome
Re: Introducing the 2023 Core Product Certification Exam + Community Badges
Thanks! I did the certification and found it fairly straightforward, although I wish there was a way to turn the missed questions into a learning experience at the end by providing more information on the questions that were missed. I want to be able to fill in the gaps in my knowledge about some of the topics, but there is no record of the specifics missed, only the general themes.
LizTo