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

Platform discussions
1

I have a formula set up and working to take a date from a column and subtract 45 days as a deadline. But some of the projects do not have a date listed because they are a special kind of project and have another column date that I want to include. how would i add that column? Essentially if Original LBDM - Planned On-Catalog date is blank than use x column and subtract 45 days.
CURRENT FORMULA:

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

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.