New Formula Error message #ERROR IN RANGE

Right now the Smartsheet formulas will pass through errors that exist in ranges referenced in formulas. This can result in error messages like "#INVALID DATA TYPE" in formulas where that is fundamentally impossible - making trouble shooting much more difficult.

If, instead of opting for passing through any existing error messages, when the formula is referencing a range containing an existing error message it would give a unique #ERROR IN RANGE message, troubleshooting for both new and experienced users would be MUCH simpler.

Sign in to vote!

Find more posts tagged with

Sheets

Formulas

functionality

Idea Submitted

Update Requests

Enhancement Request

Comments

There are no comments yet

Quick Links

Trending ideas

Automatically Identify, Notify, and Archive Inactive Smartsheet Assets
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
Allow Global Updates to build cell linking between sheets
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
Auto-resizing of Calendar App
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.