Q&A for How to Manage Priorities with Excel

Return to Full Article

Coming soon
Search
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
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

      Return to Full Article

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Combine Columns in Excel Without Losing Data