points for f1

[Pepijn]

Hi,

i need to make an app with appsheet and the subject of the app is f1. i have a point form were you can say yes or no if the driver has the fastest lap and the points. so i can fill in he finished second then the app automatticaly says he gets 18 points. but 

how do i make it so when a driver has fastest lap the app ads one point to the points. now i have this:

IF([Fastest lap] = True,
LOOKUP([_thisrow].[Finished],"PointScheme","Finished","Points")+1,
LOOKUP([_thisrow].[Finished],"PointScheme","Finished","Points"))

is there a shorter possibility

[Marc_Dillon · Accepted solution]

[Points] + IF( [Fastest Lap] , 1 , 0 )