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
Try this:
IF({CUSTOMER}="D&D", IF(DAY({Date Emptied}) > 20, 20, 10), "")
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic 
– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday
1 Like
Thanks worked amazingly …
1 Like