Fixing Errors in the Finance Planner for Creatives

All Categories  >  Troubleshooting  >  Fixing Errors in the Finance Planner for Creatives

 

Fixing Errors in the Finance Planner for Creatives

Most errors in the Finance Planner for Creatives are simple to fix and happen when dropdowns are changed, or cells are cleared or edited outside the editable areas. Here are a few common issues and how to fix them:

 


๐Ÿšฉ Flagged Dropdown Selections

If you see a red triangle or an error warning on a dropdown cell, it usually means that the selected option no longer exists in the dropdown list. This can happen if you:

  • Renamed or deleted a category, subcategory, retailer, or payment method from the editable dropdown list

  • Overwrote a cell that had a valid option with a value not included in the list

How to fix it:

  1. Click on the cell with the flagged error

  2. Choose a valid option from the dropdown list

  3. OR, if the option is still needed, simply add the desired option back to the dropdown list section on the Income or Expense sheet, and the flag will disappear

More on customizing dropdowns here  โ†’

More on formatting dropdowns here  โ†’


โš ๏ธ Protected Cell Editing Warnings

If you see a popup saying you're trying to edit a protected range, this means you're clicking a cell with formulas or locked formatting.

What to do:

  • Click Cancel when prompted

  • Double-check that you're only editing bordered, unshaded cells or the clearly labeled dropdowns sections

More on popup warnings here   โ†’

See more on which cells you should and shouldnโ€™t edit here  โ†’


๐Ÿงฎ Calculation Errors

If a chart or total isnโ€™t updating correctly, check for:

  • Missing required fields (e.g., price, date, or category - see more on required fields for income and expense logs)

  • Invalid dropdown entries (see above)

  • Incorrect formatting (e.g., entering text in a number field)


โ— Spreadsheet Errors (e.g., #N/A, #REF!, #VALUE!, etc.)

Hereโ€™s what these mean and how to fix them:

  • #N/A โ€” Usually means a formula is looking for a value that doesn't exist (e.g., trying to match a category that was deleted).
    ๐Ÿ”ง Fix: Check for missing or mismatched dropdown options.

  • #REF! โ€” Means a formula is referencing a cell or cell range that was deleted.
    ๐Ÿ”ง Fix: Try undoing your last change (Cmd+Z / Ctrl+Z), or re-copy the correct formulas from a clean copy.

  • #VALUE! โ€” Happens when a formula is using the wrong type of input (e.g., text instead of a number).
    ๐Ÿ”ง Fix: Make sure you're only entering numbers where numbers are expected.

  • #DIV/0! โ€” Appears when a formula is trying to divide by zero or a blank cell.
    ๐Ÿ”ง Fix: Make sure all relevant fields (like price) are filled out.

  • Blank Charts or Broken Visuals โ€” Often caused by missing required data (price, date, or dropdown selection). See more on required fields for income and expense logs)
    ๐Ÿ”ง Fix: Check the itemized logs for missing or invalid entries.