Hi, I’m fairly new to using formulas for Monday (or excel for that matter) and I’m trying to figure out how to do a minimum number associated with a formula column. For example, my goal is to take AxB and regardless of my inputs, if it doesn’t equal at least 300, the minimum will still be 300 unless AxB exceeds that number. Any help would be much appreciated.
Thanks in advance.
Here you go:
MAX({A}*{B},300)
The MAX() function returns the greatest value in the list given. So if 300 is greater than {A} * {B} then 300 is returned… otherwise {A} * {B} is returned.
Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 3: Dates/Times, Strings and Status
@JCorrell Thanks a bunch. Keep this in mind for the future.
Hi @JCorrell
I am your fan! I follow your channel
Could you help me ?
I would like to check between two dates which is bigger
EG: {!1ªDate} = Jan,20 and {#2ªDate} = Feb,05 => Feb, 05
But if {!1ªDate} = Jan,20 and {#2ªDate} = empty => Jan, 20
I have a scenario with two Date Colunms and also one date colunm and another date is a mirror colunm
Thanks so much
Try this:
IF({!1ªDate} > {#2ªDate}, {!1ªDate}, {#2ªDate})
Jim - The Monday Man
We Create Custom Apps, Integrations & Automations for monday