Microsoft List IF Statement for a calculed formula to another calculed formula

Question

Hi to all,

I have a these columns:

DeliveryDate in format Date

ApprovalDelivery in format Choice (Approved or not approved)

Complete_Date in format Date

Remaining Days = is a calculed column with the result in number of Today()-DeliveryDate

Based on this, I need a column with IF (I Think), if ApprovalDelivery have a text (approved or not approved), do nothing, but if ApprovalDelivery is in blank confirm if Remaining Days is less than 0 put Out of Time, if it's greater or equal put On Time.

I try to many combination of IF Statement but just give a error syntaxis.

i appreciate your support.

thanks in advance.

Answer 1

Here is a formula for you in the calculated column.

=If(AND(ISBLANK([ApprovalDelivery]),[Remaining Days]<0), "Out of Time", If(AND(ISBLANK([ApprovalDelivery]),[Remaining Days]>=0), "On Time"," "))

Note: In the Remaining Days column, data type returned from calculated formula should be set as Number.

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.