Null in IF condition

pd_njit

How do I represent null in the else clause of if statement? A blank pair of double quotes ("") is not working. I want to concatenate values is a few columns if a column is not blank. If the column is blank, I want the if statement to return null.

This code works, but I want the value in "SEQ#" to be left padded with zeros for up to 2 digits.

I want the final value in the cell to be, for example: "JD-18-01" and not "JD-18-1".

=IF(NOT(ISBLANK([Story summary]@row)), [Assigned To]@row + "-" + [Sprint#]@row + "-") + [Seq#]@row

pd_njit

Essentially, there are two issues here.

1. The value of the last column to be 01 instead of 1 (for example "JD-18-01" and not "JD-18-1".
2. If the value in [Story Summary]@row is blank, do not populate anything, in other words, leave it blank.

Paul Newcome

Solving for #2 first is as simple as moving that closing parenthesis after the second "-" to the very end of the formula:

=IF(NOT(ISBLANK([Story summary]@row)), [Assigned To]@row + "-" + [Sprint#]@row + "-" + [Seq#]@row)

Solving for #1 requires a RIGHT statement that looks like this:

=IF(NOT(ISBLANK([Story summary]@row)), [Assigned To]@row + "-" + [Sprint#]@row + "-" + RIGHT("0" + [Seq#]@row, 2))

pd_njit

Thanks, Paul. That works great. I will try to understand how it works. I did not expect RIGHT function to work here. Thanks again.

Paul Newcome

Happy to help. 👍️