Ive got 3 fields on an accounts
FieldA_c is a date field, FieldB_c is a picklist (numbers 30 60 90) and FieldC_c is a formula (date) field
the formula in fieldC is
( fieldA_c ) - VALUE( TEXT( fieldB_c ))
This works fine on accounts that were created before a specific date but fieldC_c wont populate on any new accounts created.
Any suggestions????
10 respostas
Hi Alannah,
There is no reason for the formula to not populate on new records as opposed to old ones - the problem would be in the data itself.
Here are a couple of things to check:
1. What are the API values of the picklist options for field B? Are they also numeric (30, 60, and 90) - or do they have other alphabetica or special characters in them?
2. Are you sure you're using the correct field API names in the formula?
