This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there! I am looking to add to my formula (below and attached) that when the date is blank or 0 for the field to say “due today”
CURRENT FORMULA
DATETIME_DIFF({SHIP}, NOW(), ‘days’) & " " & IF(DATETIME_DIFF({SHIP}, NOW(), ‘days’) > 0, “days remaini...
Hey Jeremy, Could I have your wisdom on another component of the formula?
If the OVERALL STATUS has the status SHIPPED or PARTIALLY SHIPPED, I would like the formula to say “shipped”.
Thank you so much for your help, Jeremy! I didn’t think anyone would respond.
Unfortunately formula did not work and I did not ask my question properly (apologies).
When the SHIP date is empty, I would like the SHIP COUNTDOWN to also be empty. When t...
