Scratching my head over this.

I don't know how to get rid of this error. Any help is appreciated.

AppSheet formula issue.pngWhat could be possibly wrong with this?

0 2 69
2 REPLIES 2

Hello

I supposed total_miles_for_job are in move details table, and there is no link between this table and the settings table.

If table settings have just one row use the function any(settings[my_setting]) to have the value. Either you have to select te correct row and use function any to have your numerical value

You are right. It worked for me. Thank You! 

Top Labels in this Space