it should be like this

=5*A2-SUM(B1:E1)

A2>Target Value

B1:E1>last 4 days data (and should be dynamic to be updated everyday )

LET(range,A1:A20,

filter,FILTER(A1:A20,A1:A20""),

sort,SORT(filter,,-1),

rows,ROWS(sort),

topvalus,IF(rows>4,TAKE(sort,5),sort),

AVERAGE(topvalus)

)

,"NO Data") ]]>

I want to express my gratitude for introducing the critical path method in Excel. It has proven to be incredibly helpful.

However, I'm currently encountering a challenge. While creating schedules, I adhere to WBS numbering, such as 1.1 and so forth. However, my work packages are further subdivided into activities, and some of my activity numbering includes formats like 1.1.1.

The current formula is not functioning as expected in these cases. Could you please assist by providing an updated formula to handle such IDs? Additionally, I am curious about how the LF and ES calculations would work if a predecessor has more than one ID in a similar format.

Thank you for your assistance.

]]>Do you get the error when you try to connect to sharepoint folder normally? That error could mean you are outside the network when you are trying to refresh or your login has expired.

]]>Is there any solution?

]]>=IF(COUNTIF(B4,"*AM*"),50,IF(COUNTIF(B4,"*PM*"),60,IF(COUNTIF(B4,"*FM*"),75,IF(COUNTIF(B4,"*CM*"),120,IF(COUNTIF(B4,"*RM*"),150,IF(COUNTIF(B4,"*CXO*"),250,""))))))

Just drag it and see the magic.

]]>