Structure for JIRA - Formulas Columns - Is EMPTY

Lexi April 10, 2023

I am not very familiar with Expr but I have gotten pretty close to what I want in place by reading through https://wiki.almworks.com/documentation/structure/latest/data-center-and-server/formulas-144998671.html and https://wiki.almworks.com/documentation/structure/latest/data-center-and-server/expr-language-141820082.html

However, I can't figure out what to use for "if the field is empty"

I have tried "is empty" "is null" "= """

I have 2 number fields (column A and column B), and I want to create column C that pulls in either value A or B based on whether column A is empty.

basically

column c = value of column A if column A is not empty or value of column B if column A is empty.

 

can someone please help me. I'm sure it is incredibly obvious.

I didn't find a forum page specifically for the ALM works structure plugin, so feel free to point me to that if they have one instead.

1 answer

1 accepted

2 votes
Answer accepted
David Niro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 10, 2023

Hello @Lexi ,

What you are looking for is "undefined".  

IF column_A = undefined:  column_B

Hope this helps!

Best,
David

Lexi April 11, 2023

this worked for me, thank you - i had tried undefined as well, but i think i was missing part of the if/else.

 

if column_A = undefined: column_B else: column_A

Like David Niro likes this
David Niro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 11, 2023

you're very welcome!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events