Column Formula with Vlookup from another sheet

Hello all, I have searched the discussion board and reviewed similar questions, however, it looks like I have my formula correct.

The convert to column formula is greyed out? Does it look correct

=VLOOKUP([Request Category]@row, {Parameters Class}, 2, FALSE)

I am using the category to pull through a duration in days for a class of project for my ticket system.

Thanks for any help.

— Gary

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/123427/column-formula-with-vlookup-from-another-sheet

Hi,

I hope you're well and safe!

Try something like this.

=VLOOKUP([Request Category]@row, {Parameters Class}, 2, false)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Gnalen

Its still not available.

isn't this the same as my formula, in the post?

Andrée Starå

https://community.smartsheet.com/discussion/comment/441141#Comment_441141

Ok.

I wanted to test whether it made a difference with non-uppercase letters, but I just remembered that it doesn't in this case.

Have you created the cross-sheet references by selecting the ranges?

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Gnalen

Hello Andree,

When I have the column type set to duration it will not work. If I change to to text it works fine.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.