Formula help if statement but want to include if blank
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)
Best Answer

Try this:
=IF(OR(ISBLANK(CustomerName@row), CustomerName@row = "NCR Intercompany"), ServiceCustomerName@row, CustomerName@row)
Answers

You can use the ISBLANK function:
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.

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

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?

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

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

Perfect  that addition was the key detail I needed 😉

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

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

Great news, glad we could help.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives