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
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.