if symbol is red retun truck number

Options

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



Answers

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Options

    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

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!