Calculating the new column value based on other other columns in a list
Is it possible to do something like following:
1) Select project(a drop down value from a column)
2) select dept( again a drop down drom a column from the list)
3) hit find new number. it will calculate next number based on earlier numbers in the list.