Is it possible to show one row per brand in my report?

Cybsss
Cybsss
edited 01/24/25 in Smartsheet Basics

Is it possible to show one row per brand in my report? i only want to show here is the what is the latest

Best Answer

  • Protonsponge
    Protonsponge Community Champion
    Answer ✓

    Hello @Cybsss

    A helper column could potentially be useful to you here.

    If you were to have a check box column in your sheet with a formula to check the MAX date for each brand, you could use that as a filter criteria in your report.

    The formula below asks if the [BRAND (if Applicable)]@row equals [BRAND (if Applicable)]@row AND also has the MAX (newest date) in [PRICE AS OF DATE]@row then show 1, else show 0. (Essentially, check the box with the newest date for each brand)

    =IF(AND([BRAND (if Applicable)]@row = [BRAND (if Applicable)]@row, [PRICE AS OF DATE]@row = MAX(COLLECT([PRICE AS OF DATE]:[PRICE AS OF DATE], [BRAND (if Applicable)]:[BRAND (if Applicable)], [BRAND (if Applicable)]@row))), 1, 0)

    In your report you can then add in the filter criteria to only show rows where [Helper - Latest Date/Brand] is checked.

    I believe this should achieve what you are looking for:-

    I hope that is helpful to you in some way,

    Protonsponge

Answers

  • Protonsponge
    Protonsponge Community Champion
    Answer ✓

    Hello @Cybsss

    A helper column could potentially be useful to you here.

    If you were to have a check box column in your sheet with a formula to check the MAX date for each brand, you could use that as a filter criteria in your report.

    The formula below asks if the [BRAND (if Applicable)]@row equals [BRAND (if Applicable)]@row AND also has the MAX (newest date) in [PRICE AS OF DATE]@row then show 1, else show 0. (Essentially, check the box with the newest date for each brand)

    =IF(AND([BRAND (if Applicable)]@row = [BRAND (if Applicable)]@row, [PRICE AS OF DATE]@row = MAX(COLLECT([PRICE AS OF DATE]:[PRICE AS OF DATE], [BRAND (if Applicable)]:[BRAND (if Applicable)], [BRAND (if Applicable)]@row))), 1, 0)

    In your report you can then add in the filter criteria to only show rows where [Helper - Latest Date/Brand] is checked.

    I believe this should achieve what you are looking for:-

    I hope that is helpful to you in some way,

    Protonsponge

  • Thank you so much! It works! @Protonsponge