-
Merged: Built-In Sheet Health Metrics: Help Us Monitor Limits Before They Break Us
This discussion has been merged.
-
IF::Then reference separate sheet
Hello I have (2) sheets I am working on. One is my Main_Running project sheet. The 2nd, I would like to populate depending on whether a column in the Main is "starred" If Column_is_starred; then I want it to pull in information from a separate Main_sheet column. I would like the 2nd sheet to only be populated if/when the…
-
How do I write a formula to use multiple columns in a single cross-sheet reference.
I am trying to set up a "combined budget" sheet that will summarize multiple budgets while maintaining the heierarchy of the original sheets. Doing this on other solutions, I have previously just set up individual column references between each sheet (most projects utilize 2 separate budgets). This will not work on this…
-
Increase Image Export Capacity Beyond 100 Rows
Hi there, We utilize Smartsheet reports for dozens of lists compiled from our master list of information. Those reports are then exported to PDF and the current problem is that the images needed for each row are not carried over to the exported report. Given the initial reason for limiting the export to 100 was back in…
-
Cell Referencing Report
A report which would provide the list of cells that are being referred from another sheet with details
-
Merged: Dynamically Update Column References
This discussion has been merged.
-
Automation Saying Cell Limit, but not at limit
I have 62 columns and 7921 rows, meaning I have 491,102 cells, well under the 500K limit. However, I am receiving an error in an automation saying the target sheet has reached its limit. Does anyone know what is causing this?
-
Confused on Cross-sheet references
I have received the below message when attempting to create a Data Collection sheet: Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references. I have read the many different cross-reference post but still find myself confused. Here is my situation.…
-
Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row") Since getting the too many cell references error i deleted about half of the columns i had and…
-
Merged: Remove Cross-Sheet Reference Limit
This discussion has been merged.