Combining data in two separate columns

Options
ScottLeeds
ScottLeeds Member
in Beast Mode

Can someone please help me learn how to combine data from two separate columns of a table? There are only two values in my pre-lease % summer 2024 column, and I need those two values to override/replace the values in the same row for the "pre-lease % 2024 column. I hope the attached screenshot helps.

Screenshot 2024-03-11 120246.jpg

Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @ScottLeeds I recommend using a beast mode with the IFNULL function to default to the Pre-Lease % Summer 2024 value when present, otherwise use Pre-Lease % 2024:

    IFNULL(`Pre-Lease % Summer 2024`,`Pre-Lease % 2024`)

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @ScottLeeds I recommend using a beast mode with the IFNULL function to default to the Pre-Lease % Summer 2024 value when present, otherwise use Pre-Lease % 2024:

    IFNULL(`Pre-Lease % Summer 2024`,`Pre-Lease % 2024`)

Categories