SharePoint Online.

Date Column A - Date when the value changed to X, 
Date Column B - Date when the value changed to Y, 

How to create a calculated

Date Column C = Recent Modification or latest change in Column A Or Column B?

closed as unclear what you're asking by Benny Skogberg May 3 '16 at 19:22

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


Column C formula is

=IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB])

I think this maybe what you are looking for but we completely need more information like "What you are really looking to accomplish;"

Try... =IF([Modified]>[ColumnA], [Modified], IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB]))


SharePoint does not record when a COLUMN value changed; if you need that you must create a Workflow and do the administration yourself

If you mean you want the maximum value of the 3 columns:

DateA or DateB or Modified (SharePoints last registered anything-in-the-ITEM changed)

it is:

=MAX( [DateA] , [DateB] , [Modified] )


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