Hello,
I have below fields into form:
Group Column - consists of 2 dropdown (Group 1 and Group 2)
Invoice Date - Date Field
Invoice No - Text Input
Status - Text input
Below is my requirement:
- If Invoice No is entered, update the text as Completed else Pending in Status column
- If Invoice Date is entered, update the text as Completed else Pending in Status column
On Default property of Status column (which is DataCardValue10), I'm using below formula, but the status is always showing as Pending
If(Len(DataCardValue4.Text)=0,"Pending","Completed", If(IsBlank(DataCardValue15.SelectedDate),"Pending", "Completed"))
DataCardValue4 is Invoice No.
DataCardValue15 is Invoice Date.
Please advise with the correct formula. Thanks!