Judith_Soto - profile

Judith_Soto · Jan 28, 2022

I track consignment items in Airtable. This is my consignment pricing structure: Day 0-29: Initial List Price Day 30-45: Initial List Price minus 15% Day 45-90: Initial List Price minus 25% Day 91: Expired What formula will auto-discount the initial ...

Judith_Soto · Jan 30, 2022

Thanks @Justin_Barrett it worked!

Judith_Soto · Jan 29, 2022

I see what you mean about nesting being tricky. I’m getting an error. I’m troubleshooting but I’m not getting very far. I don’t know much coding.

Judith_Soto · Jan 29, 2022

@JonathanB Can I ask for help with a related question? I want to create a Status column that shows the status of the consignment item as “Active” (not sold), “Sold”, “Expired” (you gave me the formula above), “Paid”, or “Unpaid” I have fields that I ...

Judith_Soto · Jan 29, 2022

Thanks so much, @JonathanB. That worked like magic!

User Statistics

User Activity

Consignment Formula Question: Auto discounting a price based on number of days that have passed

Re: Consignment Formula Question: Auto discounting a price based on number of days that have passed

Re: Consignment Formula Question: Auto discounting a price based on number of days that have passed

Re: Consignment Formula Question: Auto discounting a price based on number of days that have passed

Re: Consignment Formula Question: Auto discounting a price based on number of days that have passed