So here's the set up; I've got a list with a bunch of columns (Task ID, Task Description, Project, Start Date). It's being used as an action tracker where anyone can choose to add an item and a form will pop up. Project is a choice type column. Currently we are assigning the Task ID number manually using the format Project.FY16.1.
We want the Task ID to automatically generate but the twist is we want each project to increment separately.
For example, Lets say we have project ABC and project DEF.
We would want the first entry for project ABC to have the Task ID ABC.FY16.1and the second entry for project ABC to have Task ID ABC.FY16.2 but when the first task for DEF gets entered we want the Task ID to be DEF.FY16.1
So far the closest I've gotten is creating a calculated column using