Bug: Formula not accurate for Viewer Only

Jason Tarpinian

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.

Andrée Starå

Hi Jason,

That does sound weird and like a possible bug.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Is it published or shared as View Only? Either way... Could it have been that the sheet had been edited but not yet saved before the coworker accessed their view only version?