Reading formula result as string

[prentie]

Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s

[jsep]

This formula can be something like this:

IF(
  Approved, 
  {Team Member} & " approved off for " & DATETIME_FORMAT(Date, "MM/DD/YY"),
  "Time off request for " & {Team Member} 
)

If you need help, feel free to schedule a free call with me.

- Juan