Inspired by @Tim and his in-depth post on calculation fields: Tape calculation field Cheat Sheet, I thought I would share one that I have found useful recently.
Using emoji in a status or single select field can help make things clear at a glance:
Building a ‘Title’ using a calculation field can be very useful to show relevant information quickly, however, you don’t really need all of the status or a single select field to be in the ‘title’ field, the emoji does the job:
So how do we build a ‘title’ and only use the emoji/icon part, we can use split on the space between the emoji and the rest of the information as shown here:
`${@Organisation Type.split(" ")[0]} ${@Name} -/- ${@Organisation #}`
this can work for other things such as quickly being able to see if a Backup has errors or not:
