Formula help if statement but want to include if blank

GM185220

I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far

=IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)

KPH

Try this:

=IF(OR(ISBLANK(CustomerName@row), CustomerName@row = "NCR Intercompany"), ServiceCustomerName@row, CustomerName@row)

KPH

You can use the ISBLANK function:

https://help.smartsheet.com/function/isblank

This formula:

=IF(ISBLANK(CustomerName@row), [column to use if blank]@row, CustomerName@row)

Will return the value in "CustomerName" if it is not blank or the value in "column to use if blank" if "CustomerName" is blank.

Do you want to combine this IF with the IF you already have? If so, if the alternate column is always the same, you can use an OR, if it is different, you can nest the IFs. Let us know if you need help.

GM185220

Yes I can get this to work on its own =IF(ISBLANK(CustomerName@row), [column to use if blank]@row, CustomerName@row) but can't combine the two ? Can you help

KPH

Ho do you want them to work when combined? If the CustomerName is blank or NCR Intercompany should it return the same thing, or is there a column to return if blank and another if NCR Intercompany?

GM185220

Yes if the cell is blank or contains NCR Intercompany I wish it to return the value in another column which for both is the services column

GM185220

I’ve updated slightly as not sure it made sense 😀

KPH

Perfect - that addition was the key detail I needed 😉

KPH

Try this:

=IF(OR(ISBLANK(CustomerName@row), CustomerName@row = "NCR Intercompany"), ServiceCustomerName@row, CustomerName@row)

GM185220

Fantastic !!! - that's done the trick thanks so much for your help :-)

KPH

Great news, glad we could help.