Importing Values to a Numeric Formula Field
Any advise on how to import values from a csv file into a field with a formula or lookup? Any ideas on design change to make this work?
Forum Discussion
Lookup fields and formula fields DO NOT lend themselves to be modified by any thing other than what it is intended by. For ex. a formula field is calculated by the formula. You can't modify its value. You can however, modify the fields that contribute to this formula field. Those are the source. Likewise, a lookup field comes from its parent table. If it has to be modified, you would change its value on that table. That is the source.
So the question is: what exactly do you want to accomplish here?
So the question is: what exactly do you want to accomplish here?