Developing a Raid Log - Issue with auto gen Ref ID
I'm currently trying to develop a RAID log for my project - I am trying to create a formula that will help create an Auto Ref ID/Number that references the type of RAID issue.
What I mean is under the Ref ID column I want it to increase in consecutive order of 001, 002, 003... etc... But I want each Ref Id to start with R, A, I or D, depending on which even us selects so the Ref ID should read as -
Ref ID RAID Type
R - 001 Risk
I - 002 Issue
D - 003 Decision
the formula I am using is -
=IF(ISBLANK([Auto ref]@row),"",LEFT([Raid Type]@row, 1)+"-" + [Auto ref]@row)
But it keeps on returning #UNPARSEABLE
Could anybody help.
Help Article Resources
Check out the Formula Handbook template!