How do I make the word "false" stop showing in my JOIN formula

I have several formulas in different sheets with a JOIN formula. I am running into false showing in the column with the formula and am experiencing staff confusion with it saying that. How can I make that go away?

This is the current formula: =JOIN([NURSE TAKING ORDER/ VO AND TO ORDERS ONLY]@row:[Verbal/Telephone Order Entered By]@row)

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓


    The JOIN formula is going to combine all the values from the entire range between [NURSE TAKING ORDER/ VO AND TO ORDERS ONLY]@row and [Verbal/Telephone Order Entered By]@row. So any columns in between those are included. Are any of the columns in this range a boolean type column, such as a checkbox, flag, or star column? If so, your JOIN is turning blank boolean cells into the text value of "false".


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!