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.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |