I used to have formulas execute on the spreadsheet but I need the data to be within the app so I can manipulate it further.
The function in the sheet is:
=IFS(H2 = “”, “”, GCD(H2,2000)=2000,2000,GCD(H2,1000)=1000,1000,GCD(H2,500)=500,500,GCD(H2,250)=250,250)
Which basically says if h2 is empty this is empty (just so the sheet doesnt return REF),
then find the greatest common divisor of h2 and 2000, if it equals 2000 then use 2000. this continues down to 250.
I would like to convert this into my app but appsheet doesnt have a GCD expression, I am not very good at maths and the videos ive seen online about GCD calculate it by hand.
Does anyone know what the GCD formula in google sheets looks like using expression that appsheet has?