if symbol is red retun truck number


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


  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    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 Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!