Calculated column syntax error

Question

I use this formula for the date to appear after changing the data in the column (two answers). This formula works for me:

(IF([Approve Status]="Approved";TEXT(NOW();"dd/mm/yyyy hh:mm"))

But I need to use two answers in the formula, I try to combine them, but a syntax error appears

(IF([Approve Status]="Approved";TEXT();"dd/mm/yyyy hh:mm"));(IF([Approve Status]="Reject";TEXT();dd/mm/yyyy hh:mm"))

Can u please help me.

Answer 1

Try using this formula:

=IF(OR([Approve Status]="Approved",[Approve Status]="Reject");TEXT(NOW();"dd/mm/yyyy hh:mm"))

OR:

=IF(OR([Approve Status]="Approved",[Approve Status]="Reject");TEXT(NOW();"dd/mm/yyyy hh:mm");"")