Dec 21 2022 06:39 AM
Hello Guys
Might be easy but i have a headache here
Preface
I want the "Days in transit" Colum to stop updating the formula when I select the Yes answer in the "Arrived at destination" Colum currently the formula on "Days in transit" is "=TODAY()-G2"
i have tried =IF(L3="yes","","=TODAY()-G2")
but i don't think the formula is correct
I'm out of ideas
Dec 21 2022 06:43 AM
Dec 21 2022 06:53 AM - edited Dec 21 2022 06:55 AM
thank you that helped
Now I just need it to stop counting when yes is selected in "Arrived at destination"
the no logic is working correctly so its something i need to put in the middle i believe
=IF(L3="yes","__not sure what to put here__",TODAY()-G3)
Dec 21 2022 06:57 AM
Dec 21 2022 06:57 AM
SolutionInstead of No/Yes in the Arrived at destination column, I'd leave it blank initially, and enter the date of arrival when the item has arrived. You can then use
=IF(L2="",TODAY(),L2)-G2
Dec 21 2022 06:57 AM
SolutionInstead of No/Yes in the Arrived at destination column, I'd leave it blank initially, and enter the date of arrival when the item has arrived. You can then use
=IF(L2="",TODAY(),L2)-G2