If Statements based on column status

Melanie Sanders

Hi, I have another IF statement I am trying to work. Please see below. I am wanting to change the Date License Will Be Requested column based on what is in the RML STATUS column.

If the RML STATUS column is IN TRL-CURRENT then I would like the Date License Will Be Requested column to be Order Dispense Date column -20 days or

If the RML STATUS column is RML-CURRENT then I want the Date License Will Be Requested column to be RML EXP DATE column -20 days. I can't quite figure it out. Your help is appreciated.

Ward.Hively

Hi Melanie,

Based on your description and the image provided, you're looking to set up an IF statement to calculate the "Date License Will Be Requested" column based on the value in the "RML STATUS" column.

Here’s how you can structure the logic for the IF statement:

• If the "RML STATUS" is "IN TRL-CURRENT", the "Date License Will Be Requested" should be 20 days before the "Order Dispense Date".
• If the "RML STATUS" is "RML-CURRENT", the "Date License Will Be Requested" should be 20 days before the "RML EXP DATE".

In Excel or Google Sheets, the formula might look something like this:

=IF([RML STATUS]@row = "IN TRL-CURRENT", [Order Dispense Date]@row - 20, IF([RML STATUS]@row = "RML-CURRENT", [RML EXP DATE]@row - 20, ""))

• If the "RML STATUS" is "RML-CURRENT", it subtracts 20 days from the "RML EXP DATE".
• If neither condition is met, it returns an empty string.

Let me know if you need further assistance!