SharePoint calculated field

(0) Share

Report

Posted on by ekoz21

Hi All,

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?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ekoz21 :

Please try:

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

I've made a test for your reference:

Best Regards,

Bof