Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Functionality already exists
Workspace Planning Analytics
Created by Guest
Created on Jan 20, 2021

Planning Analytics Workspace: SUBNM formulas do not refresh in Websheets when cells are hidden

Complex Websheets require multiple references and not all have to be visible.

Needed by Date Jan 31, 2021
  • Admin
    Stuart King
    Nov 1, 2021

    I've changed the status of this enhancement to 'Functionality already exists'. All formulas are expected to work the same in Excel and TM1Web regardless of the cell being in a column or row that is hidden. This includes SUBNM functions. If you can reproduce a situation where a function is not working correctly when hidden please open a support ticket with the Excel file for review.

  • Guest
    Feb 22, 2021

    Let me give you an example: You have an Excel chart that refers to TM1 data and want to hide the data range.

  • Admin
    Stuart King
    Feb 12, 2021

    I've updated the status of the enhancement to 'Needs more information'. It's unclear what the actually expectation is in this case. I'm assuming one of the parameters in the SUBNM function is referencing another cell. Is it the subnm cell that is hidden or the cell being referenced. Is the issue that the change in the subnm not forcing a recalculation on the book?