Formula for taking data from another column if the formula set up is blank

Platform discussions
2

Hi @amber0427,

Try:

IF(ISEMPTY({Original LBDM - Planned On-Catalog Date (CT)}),
    FORMAT_DATE(SUBTRACT_DAYS({X Column},45))
    FORMAT_DATE(SUBTRACT_DAYS({Original LBDM - Planned On-Catalog Date (CT)},45)),
}

 

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.