Home

Auto pick Name from User name, Add hyperlink

karthik thenparai
Occasional Contributor

Facing the below error "Exception from HRESULT: 0xE0040035"

 

1. I have below columns in a list with validations

If [Review status] = Shortlisted (WIP), Date 2 & Project type cannot be blank

If [Review status]  =Benefit validation, Date 3 cannot be blank

If [Release date] should not be past date and cannot be >90 days from today date

If [Review status] = Benefit validation, Project type should not be blank

If [Review status] = On hold, Release date should not be blank

If [Review status] = Completed, [Closure month], [Saving realization by], [Pre metric], [Post metric] mandatory

If [Review status] = External Tech, Project type should not be blank

If [Benefit type] = Hard save & [Review status] = completed, [Annualized benefit] is mandatory and >0

If [Saving realization by] = Additional volume, Addl. volume annually should not be blank

If [Saving realization by] = FTE movement, [#FTEs moved] and [FTE movement reason] should not be blank

 

Below is the code: When clicking save in validation setting, getting this error.

=IF(AND(

                IF(

                                AND(

                                                IF([Review Status]="Shortlisted (WIP)",IF(AND([Date 2]<>"", [Project type]<>""), TRUE, FALSE),

                                                                IF([Review Status]="Benefit Validation",IF(AND([Date 3]<>"", [Project type]<>""), TRUE, FALSE),

                                                                IF([Review Status]="On Hold",IF([Release date]<>"",TRUE,FALSE),

                                                          IF([Review Status]="Completed",IF(AND([Closure month]<>"", [Projecttype]<>"", [Saving realization by]<>"", [Pre project metric]<>"", [Post project metric]<>""),TRUE, FALSE),

 

                                                          IF([Benefit type]="Hard save", IF([Annualized Benefit in USD]>”0”,TRUE,FALSE),

                                                            IF([Annualized Benefit in USD]>=”50000”,IF(AND([Review Status(Before)]=”Finance sign off > $50K”, [Review Status]=”Completed”), TRUE, FALSE),

 

                                                TRUE)))))),

                                IF([Saving realization by]="Additional volume processed",IF([Annual Addl.Vol]<>"",TRUE,FALSE),

                                IF([Saving realization by]="FTE movement",IF([#FTEs moved]<>"",TRUE,FALSE),

                                TRUE     ))),

                TRUE, FALSE),

                IF([Release date]<>"",IF(AND([Release date]>=TODAY(), [Release date]<=TODAY()+90), TRUE, FALSE) ,TRUE)

                ),

TRUE,FALSE)

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies