All Questions
2 questions
0
votes
2
answers
3k
views
SharePoint Column Formula Validation
I need to check if a column (type Number) is an Integer (no decimal).
I added this formula to the list validation:
=mod([MyField],1)=0
But I get this error:
The formula contains a syntax error or ...
2
votes
2
answers
363
views
Date Format Modifcation in List
I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...