Q&A for How to Manage Priorities with Excel

Return to Full Article

Coming soon

Add New Question

Question

My priority formula doesn't seem to work. Any ideas?

Community Answer

Make sure that you copy the formula starting with the = sign. Also, make sure your ranges in the Points sheet are properly named.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 1
Question

Where do I find priorities?

Community Answer

In step 9 you will see the formula for priorities, which you will enter (or copy/paste) into cell A2 and then copy to the rest of column A, from A3 - A10.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

For step 3, where am I supposed to enter the data?

Community Answer

In the points sheet, A1-C7. The points sheet serves to hold 3 tables of weight measurements for your tasks: importance, effort and urgency.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 1
Question

What is the Templates tab used for?

Community Answer

You can copy recurring tasks to the Templates tab so you can find and recopy them back easily.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

What do I do if I get the N/A when copy and pasting priority formulas in Excel?

Community Answer

Priority relies on the data supplied to the Importance, Effort and Urgency columns. Make sure each of these respective cells are filled in. Or just fill out Importance and Effort, then copy and paste one value for the rest. (Ramp Up = 0, Extension = 0, Today's date for Due). Keep in mind that Urgency itself relies on Ramp Up, Extension and Day(s) Left. And that Day(s) Left relies on Due date.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 2