If column is blank

hi guys,

im a new with appsheet. currently i have column [expiry date] and has auto compute with this formula

**`IF([CREATED DATE]=(""),(""),([CREATED DATE], +365))`**

if the [created date] is blank the value should be null/or empty. why is not working?

Screenshot_4

Could you try
IF(ISBLANK([Created Date]), “”, [Created Date]+365)

Hope in your post, as shown below, the asterisks and apostrophes are only included in the post and not in the expression window in the app editor itself.

3 Likes

works great,

thanks much

1 Like