-
Cross-sheet reference limitation
Hello there, I have a question about "cross-sheet reference" limitation. I receive the attached error message. I know there are limitation of number of references, however I could no find a rational for this error. I already created a sheet using a lot of references. Today I am trying to add another reference, but I…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
Cross Reference Sheet max limit
Hello, is there a workaround to this error message. It seems there is a maximum to cross referencing sheet when using the INDEX MATCH formula. I have 2 sheets with over 50 columns and need to continue index/matching each one but I hit a dead end.
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Burn Down chart with Work Insights
Hello, I was not able to find any example on how to set up smartsheet work insight to obtain a burn down chart. Could someone share how you've done it? The tutorial provided by smartsheet is vague and does not bear results. And, no examples on Youtube either. I saw one person asking the same question a couple years ago and…
-
Saving a "Form" for later use without submitting as of yet
I have employees that try to start filling out their form as they work their 8-hour shift throughout before submitting. It seems that there are times that they leave for a while, and it automatically shuts down without saving their information that they currently had in there. I heard that there is not a way to save the…
-
Deactivate form after set # of entries/submissions OR by date
It would be a great thing to be able to specify that a form be made inactive after a set # of entries. For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continue…
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
-
Connect your Smartsheet data to Claude to get real-time insights and take action
March 2, 2026 You can now connect Smartsheet directly to Claude through our new MCP Server integration, enabling you to get real-time insights, understand project health, and take action on your work, all through conversation. Claude securely accesses live sheet data to analyze task progress, overdue items, and key risks —…