Hi @David_Eastman, welcome to the community!
You are on the right track. I have a hunch that your problem is being caused by the " " at the end of your formula.
What’s happening here is that if {communication type} is NOT “Thank You Note”, you now have a single space in that field instead of nothing. This causes Airtable to see the field as a string rather than a date; causing MAX(values) to error when rolling it up.
Try getting rid of that space at the end. IF formulas in Airtable will inherently leave the value blank if the third statement is omitted.
IF({communication type} = "Thank You Note", {date})
You should be able to roll up the field as a date after that
Hope this helps!
Hi @David_Eastman, welcome to the community!
You are on the right track. I have a hunch that your problem is being caused by the " " at the end of your formula.
What’s happening here is that if {communication type} is NOT “Thank You Note”, you now have a single space in that field instead of nothing. This causes Airtable to see the field as a string rather than a date; causing MAX(values) to error when rolling it up.
Try getting rid of that space at the end. IF formulas in Airtable will inherently leave the value blank if the third statement is omitted.
IF({communication type} = "Thank You Note", {date})
You should be able to roll up the field as a date after that
Hope this helps!
Worked perfectly, thank you! I was under the impression I needed the “else” statement, even if blank.