This is not actually the context of what I’ll be using this for but rather than explaining what we do, I figure it’d be better to compare it to the old math question which is…
If I have someone that has 5 shirts, 5 pairs of pants, and 5 pairs of shoe...
I am wondering if I can take the column that’s titled “Client Lifetime Value” which is a numbers column… If the “Client Lifetime Value” is set at $37 I want it to print out “$37 Package Purchased” but if the value is $127 I want it to say “$127 Pack...
I am trying to write what I believe would be best as an IF THEN statement but I’m open to suggestions.
I have a column named client payment date and there’s a number, 1-31 there.
I want it to print out in a different column (Which I’ve named “Payment...
Greatly appreciate the help, Pete! I will go ahead and. put that into motion. Are you able to color code the table based upon what it says? Just trying to make it more easily recognizable when someone is looking at the airtable base.
IF({Client Payment Date}>=11, AND({Client Payment Date}<=20,“25th”))
This is what I have so far, but it’s displaying a 0 or a zero in the “Payment Transfer Date” column.
