I have a formula where I want “total days” to show alongside the number once the value is calculated, but while one of the date columns is empty I want the formula column to stay blank.
I was using concatenate, but it shows “NaN total days” if the date columns are blank.
CONCATENATE(DAYS({Date Completed},{Initial Pitch Date}), " total days")
Initial Pitch Date is what I want to be the “blank column” trigger.
Welcome to community
IF({Initial Pitch Date} = “” ," “, CONCATENATE(DAYS({Date Completed},{Initial Pitch Date}), " total days”))
Here is the formula.
Rehan AQ | Implementation Consultant at codexsolutionsint.com
Thanks, Rehan, but I’m getting only error messages with this formula, even with data in the two date columns.
When you copy and paste from a message, check the double-quotes. They should be straight double-quotes. You have a mix of straight and curly. That’s probably why.
What if we could break free of the Formula column and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
That did it! Thanks, Gilles!
