Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet summary field - =COUNTIFS({Range - Standard Author}; StandardAuthor@row; {Range - Status}; "In Progress") noting the…
Hi There, It is a Monday morning for me and a distinct lack of coffee means that the above formula is likely an absolute shemozzle. Essentially I am trying to return an argument that says If the Priority rating shows this (eg H5) then return this number (eg 15) in the helper column. This formula (once correct!) then also…
Hi there, I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%. Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so…
Hello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) there is a lot of other data in these sheets as well and they are over the 100,000…
