Billing from monday for storage and i want to use a formula, by pulling the info from a date column

Billing from Monday for storage and i want to use a formula, by pulling the info from a date column
if the item came in after the 20th the price should be $10 - if before the 20th the price should be $20
Thanks in advance for all the help

Here is what i made, but its not working
if(and({CUSTOMER}=“D&D”,{Date Emptied}>20),“12”,“”)
&if(and({CUSTOMER}=“D&D”,{Date Emptied}<20),“10”,“”)

I’ll be sure to keep an eye on this thread.

With our functions, you can create standalone calculations or pull data in from other columns to give you the information you need.

Summary

Subway Live IQ

@joelportprioritydoc

Try this:
IF({CUSTOMER}="D&D", IF(DAY({Date Emptied}) > 20, 20, 10), "")


Jim - The Monday Man
:magic_wand: Update Magic #1 – New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

1 Like

:pray: Thanks worked amazingly …

1 Like