Hello, Looking to fix this formula. I want a cell to be blank instead of false when not true. Please let me know if any ideas. Working in office D365
Thank you in advance. =IF(L4<>"",HYPERLINK("mailto:"&L4&" ?subject="&D4&" "&E4&" "&"Site"&" "&F4&"&""&B2&body="&""&"","Email Planner"))
Thank you in advance. =IF(L4<>"",HYPERLINK("mailto:"&L4&" ?subject="&D4&" "&E4&" "&"Site"&" "&F4&"&""&B2&body="&""&"","Email Planner"))
Last edited: