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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!