Formula IF|DATE|VLookup

What formula do you use to look at a date and if it is less than a specific date to include Vlookup formula in smartsheets?

I am trying to write a formula in SS to review the Lead Create Date and if it is less than 05/01/24, than place "No Rebate" in column. If it is 05/01/24 or greater than follow VLookup formula.

Error #INCORRECT ARGUMENT SET.

The Vlookup reviews a Name in a Group and then uses a Lookup table to determine the % of Rebate.

I would appreciate any help I can get. Thank you

Find more posts tagged with

Accepted answers

All comments

dojones

This works.

=IF([Lead Create Date]@row < DATE(2024, 5, 1), "No Rebate", VLOOKUP(Group@row, {72inc Range 2}, 2, false))

Your formula looks correct. Make sure when referencing the 2nd sheet that you are highlighting both columns in the lookup range. Also check column types if not working.

lwells

Thank you for your help it worked perfect. Now I have to figure out how to add additional "IF - Group column has "Overflow" go to No Rebate. Fun times. Thank you again.

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.