i am using this formula to populate an "all presenters" column from the "lead presenter" and "additional presenters" columns. the problem is that "all presenters" will not populate unless there is a value in "lead presenter". i'd like it to populate even if there is only a value in "additional presenters".
i did not write the formula, and am only beginning to scratch the surface, thank you for any/all help.
=IF([Lead Presenter]<>"","LEAD: "&[Lead Presenter]&IF([Additional Presenters]<>""," | "&"ADDL: "&[Additional Presenters],""),"")
Bookmarks