Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Can someone tell me what this formula string would look like?

Topic Labels: Automations Base design
581 1
cancel
Showing results for 
Search instead for 
Did you mean: 
prentie
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
jsep
7 - App Architect
7 - App Architect

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