Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Help revise IF Statement

Topic Labels: Formulas
Solved
Jump to Solution
161 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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”))

1 Solution

Accepted Solutions

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')))

See Solution in Thread

2 Replies 2

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!!!