Bug: Formula not accurate for Viewer Only

Jason Tarpinian
Jason Tarpinian ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Didn't see an official bug report page, so I hope it's OK here.

I've built a formula for a parent row to count orbs in children rows and display red > yellow > green, so if at least one red, the parent shows red, if at least one yellow, parent shows yellow.

=IF(COUNTIF(CHILDREN(Progress@row), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(Progress@row), "Yellow") > 0, "Yellow", "Green"))

It works as intended for me, but just today a coworker with viewer access had it showing yellow (it should have been red). We did a screen share and I double checked the formulas and everything SHOULD have been working to show red, but for some reason it still showed yellow. It was corrected when I updated him to Editor access. Attached is a screen shot of the report on my screen versus what he saw.

Formula Working.png

Jason Tarpinian - Sevan Technology

Smartsheet Aligned Partner