1

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?

Improve this question
1

2 Answers 2

Reset to default
1

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:

enter image description here

If this solution helps please mark as answer/vote!

Improve this answer
3

Something like this:

=IF(ISBLANK([Published date]), "", IF([Modified]>[Published date], "Yes",""))
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.