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?
Solved! Go to 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.
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
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |