Here is my worksheet, and I want have a formula like below:
If [receiving date] is not empty and [Arriving date] is empty, then [Arriving date] = [receiving date]
I don't see the IF AND function in the formula tool, so how to solve this problem...
Thank you.
UPC | Arriving date | Receiving Date |
66092121030 | 12/28/2017 | |
66092121146 | 1/5/2018 | |
66092121191 | 1/5/2018 | |
66092121245 | 12/1/2017 | |
66092121290 | 12/1/2017 | |
66092121344 | 12/1/2017 | |
6609212134 | 12/1/2017 | 12/1/2017 |
Solved! Go to Solution.
Hi @ll1100000
I think your issue may be the last part of your IF function.
Try bringing in a formula tool and setting the field to be 'arriving date'. That way, any output will be placed into this column. Our expression is then:
IF !IsEmpty([Receiving Date]) AND IsEmpty([Arriving date]) THEN [Receiving Date] ELSE [Arriving date] ENDIF