if symbol is red retun truck number

Joey Casullo
Joey Casullo ✭✭✭✭

how can I get a list of trucks whose "status" is red, im looking to do this in summary for a dashboard


image.png


Answers

  • Matt Johnson
    Matt Johnson Community Champion

    Hi @Joey Casullo

    You could create a report and filter it to show only Red in the Status column. Then add that to the dashboard using the Report Widget. The steps to do that are pretty straight forward but reach back out if you have any questions.

    I hope that helps.

    Matt

    Matt Johnson

    DigitalRadius

    Smartsheet Platinum Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!