Min Function is ignoring the blank cells
I understand that min function will ignore cells that are blank between two columns. I am wondering I will I be able to still ouput the data between two columns with one column showing data and the other not.
Here is my formula
=IF([Request Status]@row = "Approved", MIN([SQA Exception Due Date]@row, [QS Exception Due Date]@row))
If the request status is approved please return the min date from these two separate columns.
Thank you for your help
Help Article Resources
Check out the Formula Handbook template!