Use IF text lookup in a numeric formula
Hi, I have a numeric formula that calculates the amount of hours that have passed if a date/time exceeds 24 hours. If([Delivery (hours)]>24,[Delivery (hours)]-24) I would like to add the cond...
Forum Discussion
I figured it out. It's that "AND" is capitalized. I made them lowercase and now it lets me save the formula without errors.
I had no idea that this could cause conflict. Good to know.
I had no idea that this could cause conflict. Good to know.