Developing a Raid Log - Issue with auto gen Ref ID

N Kanabar
N Kanabar ✭✭
edited 02/01/23 in Formulas and Functions

Hi All,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!