UNPARSEABLE IF AND MAX FORMULA HELP
Options
Bet1996
ββ
Hi Community,
Can you tell me what is wrong with this formula? If the automatically populated created date is Max it returns 1 if not 0.
=IF(Created@row ={MAX}Created:Created),1,0)
Best Answer
-
MAX is a function, should be written with parentheses:
=IF(Created@rowΒ = MAX(Created:Created),1,0)
Answers
-
MAX is a function, should be written with parentheses:
=IF(Created@rowΒ = MAX(Created:Created),1,0)