I have the below formula, which I had support creating. I now need to add one additional rule. I would like to add that if todays date is after {Next Renewal Date (from X Customers)} then the cell should read STAGE 5 - Closed.
I have attempted this i...
I’ve created a formula to subtract no.of days from a date, this has worked, however a number of the fields are blank so returning an error, I’ve created a separate formula for that too which also works, but I don’t know how to join them together in t...
Hi Kris,
Ok so here is a screenshot of the formatting on the ‘Next Renewal Date’ field.
And here is what happens when I do your new formula in the Test column…getting True for everything…? :woman_facepalming:t2:
On another note, I would actually ...
So both of those are returning True for every field! :frowning: !
I’ve attached an image if remotely helpful to get an idea of what the sheet looks like. The ‘Next Renewal Date’ is a straightforward date pulled from the ‘Master Customer’ sheet, so s...
Thank you!
Sadly this hasn’t worked, it’s still putting “STAGE 5 - Closed” against contracts who’s renewal dates are, for example, 1 Jan 2021, 14 Feb 2021, 15 May 2021 etc., as well as the correct ones, for example, 1 Sep 20, 26 Aug 20 … any thoughts...
