tryin to if function with OR and AND

Maz Uddin
✭✭✭✭
Hi All,
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
Tags:
Answers
-
Try something like this:
=IF([Date Found]@row <> "", IF([Date Collected]@row <> "", "Collected", "Uncollected"))
-
Thank you Paul, really appreciate your response.
I actually managed to do using a different formula but yours is way more simpler
=IF(ISBLANK([Date Found]@row), "", IF(AND(ISDATE([Date Found]@row), ISDATE([Date Collected]@row)), "Collected", "Not Collected"))
Thanks once again
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!