HELP!
So I have a spread sheet which contains decimal values for week periods contained in columns. It looks for values in the cells to the right of it and if there are values in the four preceding weeks or 12 subsequent months show the text “Allocated”. If there are no values it shows “No Hours”
=IF(SUBTOTAL(9,INDIRECT(“t_Resource_Summary[@[“&c_Monday_FourWeeksAgo&”]:[“&c_Monday_12MonthsTime&”]]”))>0,”Allocated”,”No Hours”)
Since the beginning of this year it has stopped working. If I change my system date to a date last year it works again.
Does anyone know why this is…?
More importantly – can anyone correct the formula so it will work? I am a simpleton – so the least change solution is preferred!
Thanks,
J