Formula to reference another sheet

Katie Mueller

Hello,

I need to make a formula for the following and appear to be missing something or doing it wrong.

If the Date Field is filled in, then i want the Project Manager field to fill out based on a cell in another sheet.

I have the first part of =IF(Date@row >0

Paul Newcome

=IF(Date@row <> "", {Project Manager Email}, "")

<> means "not equal to" and "" means "blank".

Katie Mueller

Katie Mueller

This always happen, i end up finding the answer or sort of.

=IF(Date@row = TODAY(), {Project Manager Email}, "")

However it would really like the to have it say if the Date@row is anything but Blank, then put in the 'project manager email' from the other sheet.

Paul Newcome

=IF(Date@row <> "", {Project Manager Email}, "")

<> means "not equal to" and "" means "blank".

Katie Mueller

Perfect, thank you!

Paul Newcome

Happy to help! 👍️