Hi Ozgrid Fam,
I'm reaching out for some assistance to see how I can achieve the following:
The Action Column pulls in data from another tab.
How do I autopopulate Column M (New) with Todays date if Column I (Action) shows #N/A or 0, and Column E (Date) shows a date <= to today's date.
I've attached a spreadsheet for easier understanding.
I hope this is possible!
Thank you very much!
MK