<div>
<div class="content wysiwyg-content">
***This was posted in another Zone (MS Excel) apologies for any duplication**** <br />
<br />
I have a spreadsheet which pulls customer data from goldmine using the following syntax.<br />
<br />
=IF((GoldMine|Data!'CONTAC<wbr />T1-&gt;PHONE1<wbr />')=0,&quot;&quot;,(G<wbr />oldMine|Da<wbr />ta!'CONTAC<wbr />T1-&gt;PHONE1<wbr />'))<br />
<br />
This particular syntax pulls the phone number for the customer.<br />
<br />
My users leave this spreadsheet open all day and flick to through different cases. Sometimes the phone1 field is blank, when this occurrence happens, the previously viewed goldmine record phone number remains in view on the spreadsheet. I would like the formula to check the Phone 1 field and if its blank, then clear the cell in goldmine rather than leaving the previous phone number in view.<br />
<br />
Any ideas?
</div>
</div>


***This was posted in another Zone (MS Excel) apologies for any duplication**** 

I have a spreadsheet which pulls customer data from goldmine using the following syntax.

=IF((GoldMine|Data!'CONTACT1->PHONE1')=0,"",(GoldMine|Data!'CONTACT1->PHONE1'))

This particular syntax pulls the phone number for the customer.

My users leave this spreadsheet open all day and flick to through different cases. Sometimes the phone1 field is blank, when this occurrence happens, the previously viewed goldmine record phone number remains in view on the spreadsheet. I would like the formula to check the Phone 1 field and if its blank, then clear the cell in goldmine rather than leaving the previous phone number in view.

Any ideas?

Pulling data from Goldmine to Excel

A contact manager in its most basic form is a software program that enables users to easily store and find contact information, such as names, addresses and telephone numbers. Sophisticated contact managers provide calendar sharing features and allow several people in a company to access the same database. Some contact management systems have evolved into customer relationship management (CRM) systems to analyze and plan for an organization’s interaction with current and future customers.

Contact Management

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.