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

Dionisio Manrique 20 Reputation points
2023-05-22T20:05:00.5166667+00:00

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.

SharePoint
SharePoint
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
    2023-05-23T05:51:44.6133333+00:00

    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

    Result:

    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