IF AND function
First time here and new to Smartsheet.
In a cell I have a number. Say 400
In another cell I have a specific date. Say January 1, 2020
What I want to do as a task start date in another cell is:
If the number in the cell falls within a number range on another sheet I want the task start date to be, specific date – 18 months and so on. So if the number is 2500 then it will be specific date – 36 months.
This is the information contained in the other sheet and each number set is in a different cell.
1 - 499 18 months
500 - 1999 24 months
2000 - 4999 36 months
5000 - 9999 48 months
10000 - 14999 60 months
15000 - 35000 72 months