Hi ~
I have products that expire after 90 days if they haven’t sold.
If they sell they never expire.
I created a field named DAYS TO REMOVAL to track when products that haven’t sold are approaching their 90 day expiration date. I’d also like this field to show an NA for products that have sold and won’t expire.
I used this formula to calculate the Days To Removal
DATETIME_DIFF({Date Uploaded},TODAY(), ‘days’)
This works great for calculating the number of days before removal but it is also giving me negative numbers for products that have sold and won’t expire.
I’d like to have one of two things happens.
IDEAL SOLUTION
When my STATUS field for a product record (a single select type field) gets marked sold the Days To Removal field for that record switches to NA
SECONDARY SOLUTION
When the number of days to removal goes into negative numbers, the result switches to NA instead of showing the negative number.
I have no idea how to make my ideal solution work.
I tried this formula for my secondary solution but it came back with an error.
IF(DATETIME_DIFF({Date Uploaded},TODAY(), ‘days’)<0,“NA”,
IF(DATETIME_DIFF({Date Uploaded},TODAY(), ‘days’)))
Any help is appreciated.
