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

Dionisio Manrique 20 Reputation points

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.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,241 questions
{count} votes

Accepted answer
  1. Emily Du-MSFT 43,996 Reputation points Microsoft Vendor

    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.

    User's image


    User's image

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful