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”,“”)
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