tryin to if function with OR and AND


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

@Genevieve P.

@Paul Newcome

can you please assist me, i would appreciate it a lot



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!