Home

Auto pick Name from User name, Add hyperlink

Highlighted
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
I want users to add New lines items in response
osman_124 in Microsoft Forms on
1 Replies
Outlook meeting hyperlink issue
Kate Bowling in Outlook on
4 Replies
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies