Forum Discussion

MeredithMoore1's avatar
MeredithMoore1
Qrew Cadet
8 years ago

How do I make this work? If( IsNull([Date Complete]) and [Status]=""Completed"",ToDate([Date Modified]), [Date Complete])

This is the formula that I have. I don't know why it keeps throwing errors/ If( IsNull([Date Complete]) and [Status]="Completed",ToDate([Date Modified]), [Date Complete])
Ask about Quickbase functionality
Errors
Formulas and functions
MeredithMoore1's avatar
MeredithMoore1
Qrew Cadet
8 years ago
It is on Work Date formula, tried it as Date formula too, still not working.

Date Completed is a user input date field.