Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Min Function is ignoring the blank cells

✭✭
edited 10/26/22 in Formulas and Functions

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions