Possible to copy data to cell if only one of multiple columns contain information

Options
Justin Nicholas
edited 04/10/23 in Formulas and Functions

Greetings,

Is there a formula that can be used to copy the text from a range of columns only if there is information in that column?

For example, I have Columns [Name A], [Name B], [Name C]. Only one of these columns will be filled at the any time. If one of those columns has information, copy that information into Column D

Tags:

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓
    Options

    When you say "range" do you mean an actual range or do you mean you want every row of Column D to look at the same row to get the info?

    If the latter, then use a nested if statement and NOT IS BLANK for each. Like...

    =if(not(isblank([Name A]@row)), [Name A]@row, if(not(isblank([Name B]@row)), [Name B]@row, [Name C]@row))

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!