Hello,
Been testing ways to clean up my formula and avoid the red-exclamation-dirty-layout-kinda-thing.
Situation:
Breaking down $ per year, quarter, considering the dates in the Timeline column.
This is one of the statements:
(1) IF(OR({Approx $}=“0”, {Approx $}=0, {Timeline}=“”,{Duration}=“0”), “caught”,
IF(AND(YEAR({Timeline#Start})<2024,
YEAR({Timeline#End})=2024,
({Timeline#End})<=“2024-03-31”),
WORKDAYS({Timeline#End},“01/01/2024”)
On the (1), I’m using “caught” only as a highlight to see if the formula is catching the items that have a missing element. You can see below that it works and gives me the workdays that are part of the Quarter and displays “caught” for the odd items:
The thing is that once I add the multiplier that will bring the $ value of the quarter, I start getting the error notification on the items that have a missing element, instead of the “caught” message.
The formula now has ({Approx $}/{Duration}) so the last line is like this:
WORKDAYS({Timeline#End},“01/01/2024”)x({Approx $}/{Duration}).
Anyone has an idea of how to clean this or what the issue might be?
Thank you.