Developing a Raid Log - Issue with auto gen Ref ID

N Kanabar

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

etc...

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.

Thanks

Andrée Starå

Hi @N Kanabar

I hope you're well and safe!

Strange!

I don't see any evident errors. What do you have in the Auto ref column?

Try my example here to see if it works or not. (it works for me)

=IF(ISBLANK([Auto ref]@row), "", LEFT([Raid Type]@row, 1) + "-" + [Auto ref]@row)

Did mine work?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

N Kanabar

Hi Andree,

Thank you for responding back, could I be cheeky and ask to see a screenshot of how you set it up by any chance?

I copied your formula, and it is still producing the same error.

Thanks

N Kanabar

Andrée Starå

@N Kanabar

Happy to help!

Sure thing!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

N Kanabar

Hi Andree,

Thank you for sharing the screenshot...i feel embarrassed about this, but I made a silly error when naming my Auto Ref column, and had an extra space in the title.

Thank you so much for your help.

Andrée Starå

@N Kanabar

Excellent! Easy to miss!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!