1

I am struggling writing the formula for SharePoint calculated column.

I have 3 SharePoint Columns:

[Vaccination date]; [Infected] - Yes/No choice; [No testing is not needed (date)]

In column [No testing is not needed (date)] I would like to calculate the date a person does not need to get tested, which means I would like to add 14 days to the [Vaccination date] if the person was infected.

I have been using the following formula:

=IF([Infected]="Yes"; [Vaccination date] + 14; "")

This formula seems to work only when both columns are not blank. If one of the columns is not, then I get the default date "1900-01-13".

Any suggestions?

Improve this question

1 Answer 1

Reset to default
1

Try using this:

=IF(OR(ISBLANK([Infected]); ISBLANK([Vaccination date])); ""; IF([Infected] = "Yes"; [Vaccination date] + 14; ""))

Documentation:

Calculated Field Formulas

Improve this answer
2
  • Thank you, worked perfectly! Commented Aug 19, 2021 at 5:16
  • Hi @ekoz, Can you please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Commented Dec 7, 2021 at 12:59

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.