Comparing 2 scoring fields

Grégoire_Miche2
Level 10

Re: Comparing 2 scoring fields

Edward Unthank , would you please provide some more info? (performance, pricing, ...)

-Greg

Andy_Varshneya1
Level 9

Re: Comparing 2 scoring fields

Seconding this.

Anonymous
Not applicable

Re: Comparing 2 scoring fields

Thirding this!  Sound like everything we have needed for years!

- Erica

Anonymous
Not applicable

Re: Comparing 2 scoring fields

Easy, you can use the Excel Formulas  for Marketo. free tool on launchpoint Excel Formulas for Marketo – Marketo LaunchPoint

You don't need to know code, and pretty much every Excel formula you will ever need is easily found on Google

Yifat_Danieli
Level 3

Re: Comparing 2 scoring fields

Hi Fab Capodicasa​, your app looks great! can I do this with it?

=INDEX(A1:D1,MATCH(MAX(A2:D2),A2:D2,0))

The Excel table looks like that:

Col1Col2Col3Col4
3767

Also, if there are equal fields it will return the first one it finds.

Thanks!

Anonymous
Not applicable

Re: Comparing 2 scoring fields

Yes you can. We updated our doco to show this particular example

Diederik_Marte4
Level 6

Re: Comparing 2 scoring fields

IMPORTANT: webhooks are NOT designed for high usuage, according to Marketo suppor. Use ReST API if you can. The only native ReST API formula suite for Marketo is CALCITNOW - Field formula calculations – Marketo LaunchPoint 

6x Marketo Champion | Marketo Certified Solutions Architect (MCSA) | Marketo User Group Leader | International Speaker on Marketing Technology
Anonymous
Not applicable

Re: Comparing 2 scoring fields

That's not actually true. We use very high volume Webhooks, 140/minute for real-time scoring