How to hide a column in MS lists without loosing Conditional formating based on the information in that column

Andrey Adelberg 6 Reputation points
2022-03-02T19:01:08.22+00:00

Hi,
I have an MS List with a few different columns and I also made a "calculated" type of column. Another column is using the information stored in the "calculated" column for the conditional formatting. If I hide that "calculated" column, the conditional formatting that was linked to that column disappears. Is there a way not to display that "calculated" column in the list, but still use its contents for conditional formatting?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,865 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. JoyZ 18,046 Reputation points
    2022-03-03T04:44:09.54+00:00

    @Andrey Adelberg ,

    This is the expected behavior in SharePoint online modern experience.

    In order to add the reference to the column in JSON (column/view) formatting, we have to show that column in the list view, hiding the column from list view will not work in this case.

    Currenlty there is no workaround for this.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.