How to automate a sample number based on another number

[MTurner1]

Hi

I would like to automate a field based on the total population number and some criteria

Ie
[whole population] <10, [sample number] = [whole population]
[whole population] between 10- 100, [sample number] = 11
[whole population] >100, [sample number] = 13

I almost have it with IF formatting, but have hit a snag.

Please help!
Mari

[Marc_Dillon]

MTurner:

but have hit a snag

Which is…?

help.appsheet.com

IF()

Either/or conditional evaluation

help.appsheet.com

IFS()

First-match conditional evaluation

[MTurner1]

IF(([Dispatch Tray Quantity] < 6), [Dispatch Tray Quantity], 0)AND IF(([Dispatch Tray Quantity] < 101), 5, 0)

[Marc_Dillon]

That’s not how AND() works.

help.appsheet.com

AND()

Are all true?

I’d recommend using IFS() if you have more than 2 situations, read that doc from previous post. You can always nest IF()s though.

IF( … , … , IF( … , … , … ) )

[MTurner1]

I will give this a go, I was really just winging it. Thank you very much