Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

How to resolve formula errors when using XX as a place holder value?

Answered
Request Demo
When doing our rollforwards we put in XX as placeholders so that it can clearly indicate to readers what is still open. However anywhere that we put XX that there is a formula which is dependent of that amount becomes a #value, there should be a feature or update that allows you to put XX or some sort of character in as a place holder that will not compromise the formulas and will update the formula amount with an XX. Or maybe a way to flag cells as "open" in the workbook/spreadsheet that will show up as an XX in the document and then when you update the value you can flag the cell as "closed" so that the value will appear. We thought about leaving the values blank but then 1. the XXs are a great way to search the document and make sure that you do not inadvertently miss updating something where as a blank is not searchable and 2. if you leave it blank then the value that has the formula still populates and does not appear as an open item.
0

Comments

2 comments

Date Votes
  • Chad Zenisek
    I use a similar strategy, but I use [●] instead of XX. I add IFERROR to my formulas so that it returns [●] instead of #value.
    0
  • Mike
    Great suggestion, Chad! IFERROR would have been my suggestion for getting around this.

    I've shared your additional thoughts with our Product Team, Veronica, and will keep you updated on any new developments. Let me know if you have questions in the meantime. Cheers!
    0

Please sign in to leave a comment.