IF Formula and Auto Numbering

Angela Logie

I'm looking to use the below formula however I get an 'INCORRECT ARGUMEMT' error message:

=IF(Type@row, "Form", "F-" + [Auto #]@row, IF(Type@row, "Report", "R-" + [Auto #]@row))

Additionally, I'm looking to add this funtionality to a sheet that already has some R-XX and F-XX entries, and looking to automated the numbering from the last one and ongoing. How can I do it without messing up the numbering already in place

Thanks in advance

Kerry St. Thomas

I am making an assumption here - that there is only type "Form" and "Report" on this sheet. If that assumption is incorrect, this might not work. But I've retooled your initial formula a little.
=LEFT(Type@row,1):[Auto #]@row+"-"+[Auto #]@row

This way, you don't have a million nested IFs and can see the next step - to keep the existing R-xx & F-xx numbering.

=IF(OR(LEFT([Categorized Row ID]@row,1)="R",LEFT([Categorized Row ID]@row,1)="F"),[Existing Row ID]@row, ===THE FORMULA ABOVE===)

Good luck!

Angela Logie

Firstly, thank you for assisting. So here are all the options and their prefix's:

• Report - R-XX
• Interface - I-XX
• Conversion - C-XX
• Enhancement - E-XX
• Forms - F-XX
• Workflow - W-XX
• Label - L-XX
• RF Transaction - RF-XX

Angela Logie

Is anyone able to assist me with the above? Thanks

Paul Newcome

Try this:

=IF(Type@row = "RF Transaction", "RF", LEFT(Type@row)) + [Auto #]@row