How to indicate that a cell will be automatically calculated?
Ultimately, I want to indicate to users when a cell will be automatically calculated, so they don't overwrite the formula. I've figured it out in one case, but not in another. Both are shown below.
So, more specifically, any ideas on how to detect a blank cell when using =MAX(DESCENDANTS()) in a Date column?
I have a Project Header row with % Complete and End Date columns. I do not want dependencies turned on because I have multiple levels of indentation and only want the Project Header (top parent) row to have this behavior.
In the % Complete column, I have =IFERROR(AVG(DESCENDANTS()), "[Auto Calculated]") This works great because AVG(DESCENDANTS()) generates an error when all the descendants are blank.
In the End Date however, =MAX(DESCENDANTS()) returns a blank value/cell (no error) if there are no dates in the descendant rows, so I can't detect it with IFERROR().
The IF() function doesn't seem to evaluate DESCENDANTS() = "" or ISBLANK(DESCENDANTS()). For example, the following formulas produce, "#INCORRECT ARGUMENT SET"
=IF(MAX(DESCENDANTS() = "", "[Automatic]", MAX(DESCENDANTS())))
=IF(ISBLANK(DESCENDANTS(), "[Automatic]", MAX(DESCENDANTS())))
Thanks for any ideas!
Help Article Resources
Check out the Formula Handbook template!