Would like to generate a random number when an if statement is correct

#1

Hi there,

I’m struggling with my syntax

I’m using a formula type with the following, but it’s returning a Syntax Error when previewing the data.

if list ==“camp1” then rand(1…20) else 0

Trying to do this in Mockaroo, rather than in Excel after I’ve generated the file. I’m sure it’s a simple fix, but haven’t been able to crack it!

Thanks

Nathan

#2

Do you mind providing your schema? Grab the Public URL (lower left on the schema).