I can't seem to get my formula working.
All I need is to compare 2 date fields:
The out of the box [Modified] and a custom [Published Date].
The published date is empty until filled by a workflow.
What I want is a calculated column called Republish which says yes if [Modified] is greater than [Published date].
I'm struggling with the ISBLANK condition. Can anyone help me?
You can achieve this with this formula.
=IF([Published Date]="";"";IF([Published Date]>Modified;"";"yes")) Be aware that this formula is created in a German language SharePoint. I am not sure if English SharePoint uses semicolon (;) or comma (,) to seperate formulas. So if you get a formula error just replace the semicolons with commas.
Proof of concept:
If this solution helps please mark as answer/vote!
Something like this:
=IF(ISBLANK([Published date]), "", IF([Modified]>[Published date], "Yes","")) 