When is a column unique?


I'd like to check what makes a column unique. The source here suggests column name and column type but I thought I had read somewhere that the range of options in the dropdown (for a dropdown / select column type) made a difference too.

I'm hoping that it doesn't make a difference as I have one of my sheets where I need to enable more dropdown options but it is the same column data type as other sheets and needs to be reported on singularly.



Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓


    In my experience, it's just the column name and type that have to be the same for the data from multiple sheets to be listed in the same column on a report. With regards to dropdown lists, the columns must all be single-select or must all be multi-select. You can't mix those.


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!