Friday, September 27, 2013

SharePoint Calculated Column - IF a number column is blank

Hello,


You can try below formula:



=IF(ISBLANK(Score),"","NULL")

http://social.technet.microsoft.com/Forums/sharepoint/en-US/0c9d5ae1-132a-4e02-8a91-c54708919d9a/show-calculated-date-column-as-null-when-there-is-no-date


Hope it could help




Hemendra:Yesterday is just a memory,Tomorrow we may never see

Please remember to mark the replies as answers if they help and unmark them if they provide no help.


No comments:

Post a Comment