Find function case sensitive



I have the following formula that only works if a time is entered hh:mm pm. I can't seem to find a way to get this to accept PM. Only works with pm.

=IF(FIND("pm", [Tech Arrival Time]@row) > 0, "P", "A")

Exhausting my resources before dictating how time is entered.

Thank you in advance

Sharon C.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!