我trying to figure out a way to find the latest completed task in a Gantt. I'm using the formula below - =INDEX(COLLECT([Task Name]:[Task Name], Finish:Finish, MAX(Finish:Finish), Status:Status, "Complete"), 1) but I'm getting an invalid value error. Thanks in advance!
我trying to count the number of projects starting in a year. I am using the formula mentioned below - =COUNTIFS({Portfolio Roll-up - Start Date}, YEAR(@cell) = [Primary Column]@row) where Primary column has the number "2021". I am getting an error "#INVALID DATA TYPE". Both the columns (Primary and formula column), are…
I am getting an error while running my pivots. This happened with both new and already working pivot workflows. Has anyone else faced this issue? The logs are also not too helpful.
