Won't populate from a list created by a function

[Anne Fensie]

Hi, I love this plug-in, and it usually works. However, I added a new column to my form response google sheet to automatically number the responses using this formula: 

=ArrayFormula( IFS( ROW(B:B)=1, "Proposal ID", LEN(C:C)=0, IFERROR(1/0), LEN(C:C)>0, ROW(B:B) -1 ) )

I then created another column to combine the number with the title of the entry using this formula:

=ARRAYFORMULA(B2:B & ". " & H2:H)

No matter what I do, the resulting list won't populate in my other google form. I can see it in the preview window, but it doesn't actually load.

Thanks for your help!

Anne

[Joseph Schmidt]

Your second formula is putting a "." in every row.  If you have more than one empty row, that will cause a duplicate and FormRanger will not update with duplicates.

Remove any empty rows and formranger should work.

I had never used the IFS function.  I would have used an IF statement but what works is the important thing.  I'll have to remember the IFS for future use.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/47b5356b-63d8-4eb9-9200-50a5415f8c1bn%40googlegroups.com.

[Anne Fensie]

Ahhh....that makes sense. I removed the ". " and it works! Thanks so much!