This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Fantasy football calculator

Posted on 01-28-2022 08:10 PM
jakematthew
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi ya!

I am new to AppSheet and currently trying to recreate this spreadsheet I made as an app. The way it should work is a user enters the number of players and buy-in amount via the Form view and then the payouts and bonus values are calculated and displayed in read-only views - just like in the spreadsheet. 

I've got the formulas for the payouts working, but I'm getting hung up trying to calculate the bonuses.  across tables:  'League' and 'Bonus'. Here's what I have so far but it's not working.   

Screen Shot 2022-01-28 at 9.55.25 PM.png

Here's the app preview: https://www.appsheet.com/start/74420790-fdf5-4611-9c67-a4a245bc0211#table=League&row=ff0675d4&page=f...

If it's easier, I'd be happy to share app access. 

0 1 364
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

If you could elaborate what exactly you are trying to achieve from the expression, the community could help you better.  Also instead of sharing app ( the link you have shared is anyway not accessible) , if you could share relevant screenshots and description of table relations, it will help.

In the meantime, you may wish to try an expression something like below. 

LOOKUP([_THISROW].[Bonus ID], "League" , "League ID'",  "Total Pot")* 0.0166666666

https://help.appsheet.com/en/articles/2357309-lookup

Top Labels in this Space