Team mood using the emoji slider


@evan Shared this tip with me, and I like it so much that I wanted to post it here. On projects and teams in general, mood and motivation can be important to track. Using the emoji slider we saw in the first puzzle, you can build an easy team mood tracker for any of your docs:


And, here’s a close up of the formula:

=SwitchIf([How are you doing today?]=5,"😎😎😎😎😎",[How are you doing today?]=4,"πŸ˜€πŸ˜€πŸ˜€πŸ˜€",[How are you doing today?]=3,"😐😐😐",[How are you doing today?]=2,"😣😣",[How are you doing today?]=1,"😱", [How are you doing today?].IsBlank(),"πŸ‘ˆπŸ‘ˆπŸ‘ˆ choose from 0-5!")