Forum Discussion
Solved
Equal to or less than calculated Column
Looking to calculate is a date is less than or equal too calculated column which I have partly working, however if the date is blank its treating that as equal too or less than. How can I build in if...
Hi Kate_McCulloch please check this
Episode Check =IF (ISBLANK(FMRTS[Episode Start Date]),"No",IF (FMRTS[Episode Start Date] <= FMRTS[Form Start Date],"Yes","No"))
techies
Super User
Super UserHi Kate_McCulloch please check this
Episode Check =
IF (
ISBLANK(FMRTS[Episode Start Date]),
"No",
IF (
FMRTS[Episode Start Date] <= FMRTS[Form Start Date],
"Yes",
"No"
)
)
This worked exactly how I needed thank you
- techies
Welcome 🙂