[Issue]: Add upload validation for conditional IAA Fields

[ClaireValdivia]

Why is this issue important?

In 2024, treasury added conditional IAA fields. Partners (specifically Marcus from RI) has requested that conditional logic be added to upload validation to ensure that these fields are completed when they are conditionally required.

Current State

Conditional formatting is applied in the input template so if Award_Type__c has a value of "Interagency Agreement (IAA)", the fields IAA_Basic_Conditions__c and IAA_Requirements_Attestation__c display as unshaded. If any other value is selected from Award_Type__c or if that field is blank, the IAA fields display as shaded.

there is no upload validation requiring the IAA fields.

Expected State

The two IAA fields are: IAA_Basic_Conditions__c and IAA_Requirements_Attestation__c. Each field is conditionally required if Award_Type__c has a value of "Interagency Agreement (IAA)"

This ticket is to add the following upload validations:

• If Award_Type__c has the value "Interagency Agreement (IAA)" and IAA_Basic_Conditions__c is blank, then an error should generate with the message field: "Value is required for IAA_Basic_Conditions__c" and the relevant workbook tab, row, and column are listed with the location of the IAA_Basic_Conditions__c field
• If Award_Type__c has the value "Interagency Agreement (IAA)" and IAA_Requirements_Attestation__c is blank, then an error should generate with the message: "Value is required for IAA_Requirements_Attestation__c" and the relevant workbook tab, row, and column are listed with the location of the IAA_Basic_Conditions__c field
• If the Award_Type__c has the value "Interagency Agreement (IAA)" and IAA_Basic_Conditions__c and IAA_Requirements_Attestation__c both have values, then no error will generate
• If the Award_Type__c has any value except for "Interagency Agreement (IAA)" and IAA_Basic_Conditions__c and/or IAA_Requirements_Attestation__c is blank, then no error should generate

Implementation Plan

The following functions need to be added...

Relevant Code Snippets