Null in IF condition

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

Find more posts tagged with

Accepted answers

All comments

pd_njit

Essentially, there are two issues here.

The value of the last column to be 01 instead of 1 (for example "JD-18-01" and not "JD-18-1".
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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.