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.


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


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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!