Conditional formatting to alternate shading of rows based on a field
I've created a sheet to track an IRB's review of projects. Each IRB committee member fills out a form as they review each project, then they use the sheet that's populated by the forms when they meet to review multiple projects. I want to make it easy for them to see at a glance what the responses were for each project, without having to use filters. So, I want to use conditional formatting using the TMSS ticket number field to shade the projects in alternating colors, white and light grey. The number of rows per project is not always the same, because sometimes there are different numbers of people reviewing different projects. Is there an automated way to do this in Smartsheet? I've included a screenshot of what I want it to look like.