Keypup

Syntax: <code>IF(condition, value_if_true, [value_if_false])</code> or alternatively the shorthand version <code>condition ? value_if_true : value_if_false</code>

Description: If the first argument evaluates to <code>true</code> then it returns the second argument, otherwise it returns the third argument (or null if none is provided). The second and the third arguments must have the same type.

<code>IF(updated_at &gt; created_at, updated_at, created_at)</code> will always return <code>updated_at</code> by definition

<code>IF(1 &gt; 2, "some result")</code>returns <code>null</code>

<code>lines_changed &gt; 500 ? "Big PR" : "Small PR"</code> returns “Big PR” for all pull requests with more than 500 lines of code changed and “Small PR” otherwise.

<code>IF(CONTAINS(label_names, ["defect", "bug", "fix"]), "Bug ", "Feature")</code> returns <code>Bug</code> if one of the defined labels is found, otherwise returns <code>Feature</code>. This is used to remap fields.

- <code>IF(updated_at &gt; created_at, updated_at, created_at)</code> will always return <code>updated_at</code> by definition
- <code>IF(1 &gt; 2, "some result")</code>returns <code>null</code>
- <code>lines_changed &gt; 500 ? "Big PR" : "Small PR"</code> returns “Big PR” for all pull requests with more than 500 lines of code changed and “Small PR” otherwise.
- <code>IF(CONTAINS(label_names, ["defect", "bug", "fix"]), "Bug ", "Feature")</code> returns <code>Bug</code> if one of the defined labels is found, otherwise returns <code>Feature</code>. This is used to remap fields.

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you