Nicole_Abascal - profile

Nicole_Abascal · Nov 09, 2022

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...

Nicole_Abascal · Nov 10, 2022

Brilliant!! That did the trick and it looks incredible. Thank you so so much!

Nicole_Abascal · Nov 10, 2022

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”.

Nicole_Abascal · Nov 09, 2022

Thank you so much, Jeremy! It worked and appreciate your help/patience!!

Nicole_Abascal · Nov 09, 2022

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...

User Statistics

User Activity

Need help correcting the NaN from my formula

Re: Need help correcting the NaN from my formula

Re: Need help correcting the NaN from my formula

Re: Need help correcting the NaN from my formula

Re: Need help correcting the NaN from my formula