Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counter on Report

Lisa Doyle
edited 12/09/19 in Archived 2016 Posts

Is there a way to add a column to a report?


I have multiple SmartSheets managing Test Scripts in multiple functional groups and I want to create a bug report for the developer that searches them all and only shows them the "Fails", but I would like the failures to get a unique identifier. Is it possible to add a column that creates a counter (i.e. CAS-0001) for reporting purposes?


I am using the ryg balls to manage the fails (r = fails, y = ready for retest, g= fixed). The "bug" report will be a permanent record so items will remain on the list even after they are fixed because the formula on the Test Script Sheets looks for any value in the Fail column to mark a "Failure".


Thank you,




  • Greg Hawk

    Hi Lisa, reports cannot have any unique columns. You could add a failures counter to each sheet then add it to the report. But with this method, you could turn on auto-numbering on each sheet (Which would add a number to each row and will not take into account failures from other sheets) or you could manually add a counter on each row once it is added to the report. 

This discussion has been closed.