Chossing status

Hello all I have these two fields the is the “amount used” and “Status”
what I want to do is when the “amount used” is empty I want “pending” when the “amount used” is “0” I want “Void” and when the “amount used” is greater than “0” I want “Used” On status is a single select! Screen Shot 2021-10-22 at 9.13.54 PM|173x500


You cannot really do this with a single select option, in fact there is little you can do with that field type.

Even with a formula field it is not straightforward as a blank cell and 0 report as the same thing. Look at Differentiating between blank and zero

Taking that into account a formula would still result in the best option for you. A nested IF() would likely perform the best:

IF(COUNTA({Amount Used}) = 0, “Pending”,
IF({Amount Used} > 0, “Used”,
IF({Amount Used} = 0 ,“Void”, “”)))

The first line of this formula looks to see if the cell is indeed blank or is just recorded as a zero value. If it is indeed blank if brings back the word “Pending”
The second and third lines above utilize basic comparisons to bring out the other two states you are seeking.

While this will not provide you with a sleek single select type button field, it would appear that you are not looking for that field type. You do not want to alter this cell individually but would rather have the airtable do the work for you. If you are looking to jazz up the look of the returned language I would suggest adding emjoi characters or something, see the listing on conditional formulas with emojis Or if you are on the paid plan you can use conditional formatting to alter color on the entire record.

Hope this helps

Thanks for your reply but I don’t know how to make it work I tried that formula but I still don’t know what to do.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.