Populating empty columns

[peterg97]

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!

[Qiu · Accepted solution]

@peterg97 
Something like this?

[Emil_Kos · Accepted solution]

Hi @peterg97,

This is the formula that you need to use:

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

My output:

[peterg97]

Hi @Qiu 

Thanks, this works perfectly! Appreciate the help. 

Kind Regards, 

Peter. 

[peterg97]

Hi @emil 

Thanks! Appreciate the help!

Kind Regards, 

Peter. 

[Qiu]

@peterg97 

Thank you for the accept mark also