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)]
[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