If/Then copying cell information
I'm sorry if this is posted- I haven't found an example from previous posts that is working for my situation.
I have 2 name columns- [First & Last Name] and [PI First & Last Name], and a third column for 'role'- [Study Role]. If the person picks the role I need (PI) I'd like copy the name of the 1st name column to the 2nd- so that they do not have to duplicate entry; but I need the second to send in an Update Request.
I think the formula is =IF([Study Role]@row = "Principal Investigator", [First & Last Name], BLANK
I don't think the BLANK is right- but with it or with out it i still get a #UNPARSEABLE
Help Article Resources
Check out the Formula Handbook template!