Skip to main content
Solved

Help revise IF Statement

Nedra_Hines
Forum|alt.badge.img+10

Hello community! I have the below if statement that needs revising. The issue is that the formula assumes zero when DeStaging Date is blank, when in fact, I want to see the result from the rest of the formula to popup on my Google Calendar. What should I add?

IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},“No renewal charge”,CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”))

Best answer by Vivid-Squid

Hi @Nedra_Hines
So IF there is no date, you want to see the concatenation text, if there is a date run the formula as you have it.

Try to plug that into another IF statement.

IF({DeStaging Date} != "", IF({DeStaging Date}<{Monthly Rental Fee Renewal Date}, 'No renewal charge', CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date}, 'MM-DD-YY'),'|',{Client Name},'|','Rental Fee Renewal Date')))
View original
This topic has been closed for replies.

2 replies

Forum|alt.badge.img+16

Hi @Nedra_Hines
So IF there is no date, you want to see the concatenation text, if there is a date run the formula as you have it.

Try to plug that into another IF statement.

IF({DeStaging Date} != "", IF({DeStaging Date}<{Monthly Rental Fee Renewal Date}, 'No renewal charge', CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date}, 'MM-DD-YY'),'|',{Client Name},'|','Rental Fee Renewal Date')))
Nedra_Hines
Forum|alt.badge.img+10

Hi @Nedra_Hines
So IF there is no date, you want to see the concatenation text, if there is a date run the formula as you have it.

Try to plug that into another IF statement.

IF({DeStaging Date} != "", IF({DeStaging Date}<{Monthly Rental Fee Renewal Date}, 'No renewal charge', CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date}, 'MM-DD-YY'),'|',{Client Name},'|','Rental Fee Renewal Date')))

Thank you so much for your answer! That worked perfectly!!!

Terms & ConditionsAccessibility statement