Skip to content

cptSaveLocal (ECF to LCF) - fix/improve MATCH formula; add conditional formatting #505

@AronGahagan

Description

@AronGahagan

Problems:

  1. The MATCH formula only takes the last four subprojects in the EXACT comparisons.
  2. Slight discrepancies (i.e., a typo) are not immediately evident.

Solutions:

  1. Use =IF(COUNTA(UNIQUE([range],TRUE))=1,TRUE,FALSE)
  2. Use conditional formatting; assume MASTER has correct LCF Custom Field Name

Todo:

  • assign this issue
  • assign issue type (Bug, Feature, Task)
  • label the issue with codemodule (so fixes can be aggregated and hotfixed together)
  • checkout appropriate branch and create topic branch
  • design, code and test
  • update codemodule <cpt_version>x.y.z</cpt_version>
  • update CurrentVersions.xml manually
  • commit message should begin with Issue #XXX -
  • commit the change(s)
  • merge topic into appropriate branch(es) and push
  • delete topic branch

Metadata

Metadata

Assignees

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions