tryin to if function with OR and AND
If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected
if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected
if the 'Date found' column is blank, column7=blank
Can anyone please try help
can you please assist me, i would appreciate it a lot
Help Article Resources
Check out the Formula Handbook template!