Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 05, 2022 04:34 PM
This is obviously very much related to my last question, but have a formula that is calculating the average score (0-5) from multiple judges.
I’d like to create a Kanban view based on that average and I’m trying to figure out the best way to do that. I can round off to the nearest whole number, but Kanban requires a single select to create a view. Is there a clever workaround that would let me accomplish this?
Jul 05, 2022 07:35 PM
You could add a Single Select option that has one option for 1 through 5. Then set an Automation to run when the record’s formula field value changes, and put an Update Record action step that copies the value from the formula to the single select. I would also set the field permissions to “Nobody can edit, except automations” that way you don’t accidentally edit up the single select values.