Forum Discussion

Brass Contributor

Nov 05, 2018

Solved

Sharepoint calculated column if date greater than another column

Hi guys, I have two fields on my Sharepoint list. One of them is called 'From Date' and another one called 'To Date'. How do I create a formula that validates if To Date is greater than From Dat...

Rafael Benicio
Nov 06, 2018
Hey Matt Weston,

I thought it was working but it's not! Just noticed, the validation is not working properly.

The formula that works is this one =[To Date]>=[From Date].

Rafael Benicio

Brass Contributor

Nov 06, 2018

Matt Weston Never mind, I put the formula in the validation settings under list settings and it worked.

Thank you so much! Cheers!

Rafael Benicio

Brass Contributor

Nov 06, 2018

Hey Matt Weston,

I thought it was working but it's not! Just noticed, the validation is not working properly.

The formula that works is this one =[To Date]>=[From Date].

Matt Weston
Iron Contributor
Nov 07, 2018
Hi Rafael Benicio, yes that is how the formula would be for list validation. Apologies, the original formula I gave you was for a calculated column.
- CharlesDK
  Copper Contributor
  May 27, 2020
  Hi Matt Weston
  
  I am getting an error message for the same formula (different column names)
  
  =[End Date of Action]>=[Start Date of Action]
  
  Error:
  Sorry, something went wrong
  The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column.
  
  Do you have a suggestion as to what the solution is?
  
  Many thanks!
  - CharlesDK
    Copper Contributor
    May 27, 2020
    Fixed my error - this has to be a list validation, not a column validation!
    https://social.msdn.microsoft.com/Forums/sharepoint/en-US/4e4659a7-fced-47e3-8005-2943d390099e/sharepoint-2013-the-formula-cannot-refer-to-another-column?forum=sharepointdevelopment