Pulling Date From Cross Reference Sheet

loc.le

Hi there, I have a column full of dates from the source sheet, which I want to populate a column in main sheet if the date is within the next 30 days. Based on that date from the source sheet, if it is within the next 30 days, I want it to pull the cell in the same row in a different column.

I have this so far but it's #unparseable. The references are correct (selected the column)

=IF(AND({Target Pull Date}@row >= TODAY(), {Target Pull Date}@row <= TODAY() + 30), {Protocol Number}@row , "")

What's happening here?

loc.le

Source sheet

Andrée Starå

https://community.smartsheet.com/discussion/140079/pulling-date-from-cross-reference-sheet

Hi,

I hope you're well and safe!

You can't use the @row with a cross-sheet reference. @row is used in the sheet it's in.

=IF(AND({Target Pull Date}@row >= TODAY(), {Target Pull Date}@row <= TODAY() + 30), {Protocol Number}@row , "")

Make sense?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏