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

Answers

  • dojones
    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.

  • 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!