question

Johnkelly-2318 avatar image
0 Votes"
Johnkelly-2318 asked JinweiLi-MSFT answered

Sharepoint Calculated Column IF Statements

Here's my formula:

=IF(Status="Completed",IF([JCN Type]="EDLM","UDLM",[Date Completed]+10),IF([JCN Type]="EA","TA",[Date Completed]+15))

I also want to have to be 10 or 15 work days but not really sure how to tie that in. Also, my third IF statement doesnt add any date in the field it add UDLM.

office-sharepoint-onlinesharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JinweiLi-MSFT avatar image
0 Votes"
JinweiLi-MSFT answered

Hi @Johnkelly-2318,

Please try to use this:

 =IF(Status="Completed",IF(OR([JCN Type]="EDLM",[JCN Type]="UDLM"),[Date Completed]+10,IF(OR([JCN Type]="EA",[JCN Type]="TA"),[Date Completed]+15)),"")

Output:

206528-image.png


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.



image.png (23.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sreejukg avatar image
0 Votes"
sreejukg answered

You may use OR Function inside your if to make sure you joins multiple statements toghether.

https://support.microsoft.com/en-us/office/or-function-9a2a1cca-696f-4d19-a959-3943babd076f

Similar to OR, there is And function too. Please refer

https://support.microsoft.com/en-us/office/and-function-78956048-53c7-484a-ab0b-6e70d7f03400

Hope this helps

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.