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?

3X_e_2_e263df8f80bd1c831c93cdeb65fc45ade9ad77fa.jpeg

Solved Solved
0 2 1,899
1 ACCEPTED SOLUTION

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.

View solution in original post

2 REPLIES 2

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.

works great,

thanks much

Top Labels in this Space