Hi
I have this formula.
=IF(F176<>"",IF(G176="",NOW(),G176),"")
I need to auto time stamp if the text is "received" and leave it blank if nothing or other texts are typed in the cell F176. Formula will be in G176. Please advise.
Hi
I have this formula.
=IF(F176<>"",IF(G176="",NOW(),G176),"")
I need to auto time stamp if the text is "received" and leave it blank if nothing or other texts are typed in the cell F176. Formula will be in G176. Please advise.
Last edited by Shamz41; 02-24-2015 at 01:17 PM.
Do you have iterations on in Excel Options?
Then simply modify the formula
=IF(F176<>"Received", IF(G176="",NOW(),G176),"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi yes I have iterations on. but the formula is showing a reverse solution.
when I input this formula and I key in received the cell shows blank
and when I key in other text or leave it blank it shows date timestamp.
I need it to be the other way round.
received - date timestamped
blank/other text - blank
Sorry
=IF(F176="Received", IF(G176="",NOW(),G176),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks