Pulling Date From Cross Reference Sheet

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?

Find more posts tagged with

Accepted answers

All comments

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! 🙏

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.