Set( varStatus, If( (!IsBlank(ConSupplier1) && !IsBlank(ConSupplier2) && !IsBlank(ConSupplier3)) || (!IsBlank(AOBW_Presidnt_Signature_Value) && !IsBlank(AOBW_CFOSignature)), "Review", IsBlank(ConSupplier1) || IsBlank(ConSupplier2) || IsBlank(ConSupplier3), "Pending Bid Waivers", !IsBlank('IT ReviewedByValue') && !IsBlank(FinanceReviewedByValue) && !IsBlank(PurchasingReviewedByValue), "Pending CAR Approvals", !IsBlank(BryComp_VP1_Signature_Value) && !IsBlank(BryComp_SVP2_Signature_Value) &&
!IsBlank(BryComp_SVP3_Signature_Value) && !IsBlank(BryComp_SVP4_Signature_Value) &&
!IsBlank(BryComp_VP1_Signature_Value) && !IsBlank(BryComp_VP2_Signature_Value) &&
!IsBlank(BryComp_VP3_Signature_Value) && !IsBlank(BryComp_VP4_Signature_Value) &&
!IsBlank(BryComp_President_Signature_Value) && ​!IsBlank(BryComp_CEO_Signature_Value) &&
​​​​​​​ !IsBlank(BryComp_Other_Signature_Value), "Legal & Purchasing Approvals", !IsBlank(LegalApproverSignatureValue) && !IsBlank(PurchasingApprovalSignatureValue), "Asset Management", !IsBlank(AssetMangReviewerValue), "SAP Purchasing Review", AOBW_President_DropDown.Selected.Value = "Deny", "Rejected"
) )
//Set Status Values
If(
IsBlank(ConSupplier1) || IsBlank(ConSupplier2) || IsBlank(ConSupplier3),
Set(
varStatus,
"Pending Bid Waivers"
)
);
If(
!IsBlank(ConSupplier1) && !IsBlank(ConSupplier2) && !IsBlank(ConSupplier3),
Set(
varStatus,
"Review"
)
);
If(
!IsBlank(AOBW_Presidnt_Signature_Value) && !IsBlank(AOBW_CFOSignature),
Set(
varStatus,
"Review"
)
);
If(
!IsBlank('IT ReviewedByValue') && !IsBlank(FinanceReviewedByValue) && !IsBlank(PurchasingReviewedByValue),
Set(
varStatus,
"Pending CAR Approvals"
)
);
//Bryce Company Approval
If(
!IsBlank(BryComp_VP1_Signature_Value) && !IsBlank(BryComp_SVP2_Signature_Value) && !IsBlank(BryComp_SVP3_Signature_Value) && !IsBlank(BryComp_SVP4_Signature_Value) && !IsBlank(BryComp_VP1_Signature_Value) && !IsBlank(BryComp_VP2_Signature_Value) && !IsBlank(BryComp_VP3_Signature_Value) && !IsBlank(BryComp_VP4_Signature_Value) && !IsBlank(BryComp_President_Signature_Value) && !IsBlank(BryComp_CEO_Signature_Value) && !IsBlank(BryComp_Other_Signature_Value),
Set(
varStatus,
"Legal & Purchasing Approvals"
)
);
If(
!IsBlank(LegalApproverSignatureValue) && !IsBlank(PurchasingApprovalSignatureValue),
Set(
varStatus,
"Asset Management"
)
);
If(
!IsBlank(AssetMangReviewerValue),
Set(
varStatus,
"SAP Purchasing Review"
)
);
If(
AOBW_President_DropDown.Selected.Value = "Deny",
Set(
varStatus,
"Rejected"
)
)