Populating empty columns

Hi All,

I am trying to populate a column using an IF function, but not sure how to do it. Basically, I want use an IF function to check if a row in a column is null, and if it is, I want to replace it with the first 4 characters of a different row. I've attached an example to help visualise (For the rows that are Null, I want the first 4 letters ie 2017, 2018 and 2011 to populate the year column):

Any help would be appreciated.

Hope everyone had a good New Years!

Cheers!

Datasets

Expression

Data Investigation

Accepted answers

@peterg97
Something like this?

0107- peterg97.PNG

0107- peterg97.yxmd

This is the formula that you need to use:

IIF(IsNull([Year]), ToNumber(Left([Order], 4)) , [Year])

My output:

All comments

@peterg97
Something like this?

0107- peterg97.PNG

0107- peterg97.yxmd

This is the formula that you need to use:

IIF(IsNull([Year]), ToNumber(Left([Order], 4)) , [Year])

My output:

Thanks, this works perfectly! Appreciate the help.

Kind Regards,

Peter.

Thanks! Appreciate the help!

Kind Regards,

Peter.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703