I have 2 field:
- Effective Date (date field entered by user)
- Billing Begins (Months) (number field 1-5 entered by user)
If effective date = 01/01/2021 and billing begins is 4 / I need another field that will auto populate a date of 05/01/2021 (so the number field is how many months UNTIL billing is started / and the new field shows the actual date)
How can I do this?
5 respostas
Hi Christopher,
What are the options in the picklist?
If the picklist contains something line 1,2,3 etc.. then you can use the below formulaIF(
AND(
NOT(ISBLANK(Effective_date__c),
NOT(ISBLANK(TEXT(Billing_Begins__c)))
),
ADDMONTHS(Effective_Date__c,VALUE(TEXT(Billing_Begins__c))),
NULL
)
