Pulling data from Goldmine to Excel

***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?
daiwhyteAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GMGeniusConnect With a Mentor Commented:
I left a message on that question , you have not responded to it, it might shed some light
0
 
daiwhyteAuthor Commented:
Thank you.
0
All Courses

From novice to tech pro — start learning today.