For most field types, you can check if a cell has a value with an IF function.
IF(
{Date},
DATETIME_FORMAT({Date}, "MMMM D, YYYY h:mm A"
)
Notice that you can simply use the field name without comparing the field value to BLANK() or an empty string "".
However, if the field is a number field, and zero is a valid value, you need a different technique. Comparing the number to BLANK() won’t work because Airtable thinks that BLANK() is the same as 0. Instead, you can turn the field into a text string to see if there is a value.
IF(
{Number} & "",
"✔️"
)
If you want to see if a set of fields all have values, use the AND() function.
IF(
AND(
{Date},
{Number} & ""
),
DATEADD({Date}, {Number}, 'days')
)
