Text calculations are written in the same way as simple calculations; however, a text calculation returns a result in text (string) format.
Nested if statements are often used for text calculations, because they allow you to check for multiple conditions sequentially and return a value based on one of those conditions being met. This example shows a nested if statement in a text calculation.
This equation first checks if Sprint 1 is less than (i.e. faster) than Sprint 2. If it is, it returns the text string Sprint 1. If not, it performs a second if statement, which checks if Sprint 2 is less than Sprint 1. If it is, return the text string Sprint 2. If it isn’t, then they must be equal, so the calculation returns Tie.
A text calculation can be used to convert a date into a text string, as shown below. This example uses the dateformat function to re-formate a date field into text using the EEE variable, which returns the first three letters of the weekday. If needed, an option calculation can further be used to convert the text into full weekdays.