Microsoft Office 16 - Agile Roadmap template

Hi All

Does anyone use the Microsoft agile roadmap template.

It has been working great for me.

However I want to add another category "Awaiting response" to the target data and for this to then feed through into another column in the roadmap sheet.

I've created the new column, however it is only ever populated by the first row of data irrespective of what category that task is assigned to.

Thank you for your help

Andy

Answer
Answer
The reason is that all formulas are Array formulas. You have entered the formula as non Array.

Array Formula is not entered by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. If you are copying and pasting this formula, take F2 after pasting and CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually.
Sincerely yours,
Vijay A. Verma | Blogging @ https://excelbianalytics.com | Linkedin @ https://www.linkedin.com/in/excelbi/

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 224 Applies to: