1

I want to make a formula to my calculated column :

If the DD Rating is High => Add 3 months to the [DD Sign-off Date] If the DD Rating is Medium=> Add 6 months to the [DD Sign-off Date] If the DD Rating is Low => Add 12 months to the [DD Sign-off Date]

So the formula must be like this :

  =IF([DD Rating]="High",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+3,DAY([DD Sign-off Date])),"dd/mm/yyyy")),
   IF([DD Rating]="Medium",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+6,DAY([DD Sign-off Date])),"dd/mm/yyyy")),
   IF([DD Rating]="Low",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+12,DAY([DD Sign-off Date])),"dd/mm/yyyy"))
  • So what is the problem with this formula? are you getting an error whilw saving this formula? – Ganesh Sanap Nov 27 '18 at 9:38
  • Yes when i save I get an error: Sorry, something went wrong – Jihen Nov 27 '18 at 9:40
  • Is DD Sign-off Date is required column? – Ganesh Sanap Nov 27 '18 at 10:07
1

All example formulas in this topic use commas "," as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons ";" as the delimiter character.

Try using:

=IF([DD Rating]="High";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+3;DAY([DD Sign-off Date]));"dd/mm/yyyy");
   IF([DD Rating]="Medium";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+6;DAY([DD Sign-off Date]));"dd/mm/yyyy");
   IF([DD Rating]="Low";
TEXT(DATE(YEAR([DD Sign-off Date]);MONTH([DD Sign-off Date])+12;DAY([DD Sign-off Date]));"dd/mm/yyyy"))))
0

Try Using below Formula:

=IF([DD Rating]="High",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+3,DAY([DD Sign- off Date])),"dd/mm/yyyy"),
   IF([DD Rating]="Medium",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+6,DAY([DD Sign-off Date])),"dd/mm/yyyy"),
   IF([DD Rating]="Low",
TEXT(DATE(YEAR([DD Sign-off Date]),MONTH([DD Sign-off Date])+12,DAY([DD Sign-off Date])),"dd/mm/yyyy"))))
  • 1
    Same Problem :( – Jihen Nov 27 '18 at 10:22
  • Strange. I tried this and it is working on my site. make sure you are returning your calculated column as "Single line of text"(option given below formula) and DD Sign-off Date is date and time field. – Ganesh Sanap Nov 27 '18 at 10:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.