I can confirm that a Data Type Column cannot be used in a Formula. But there is an easy workaround using Workflows in SharePoint Designer 2010/2013 without any coding required
- Create an additional Column in your list (DataTypeColumn01) as type Single Line Text
- In SharePoint Designer, open the List from the specific website and click New on the Worflows tab
- Give the Workflow an appropriate name and select the Platform; either SharePoint 2010 /2013 Workflow
- From Workflow Tab select Action – List Actions – Set Field in Current Item
- Set DataTypeColumn01 to CurrentItem:DataTypeColumn
- Use the lookup button next to the Action to achieve this
- Save the Workflow
- Enable the Start Options for the Workflow as per your requirement
- Publish the Workflow
- You can now use the DataTypeColumn01 Column with any SharePoint Formula
SQL Database ‘SharePoint_Config’ on SQL Server instance ‘GDFS’ not found. Additional error information from SQL Server is included below.
Cannot open database “SharePoint_Config” requested by the login. The login failed. Login failed for user ‘GOLTENSDXB\SP_Farm’.
Before you go about making any drastic changes to the database; it would be wise to check the Status of the Sharepoint_Config database within the SQL Server Management Studio
Is your Sharepoint_Config Database set to Single User Login?
If yes, we require the trace and kill the session that is connected to this database before we enable multi user
Step 1 – Trace the Session ID connected to the Sharepoint_Config Database
select * from master.sys.sysprocesses
Step 2 – Kill the Session and set the Sharepoint_Config Database database to offline mode
kill <spid> [eg: kill 62]
alter database Sharepoint_Config set offline with rollback immediate;
Step 3 – Switch back the Database to Online Mode and set it for Multi-User login
alter database Sharepoint_Config set online,multi_user with rollback immediate;
If your Sharepoint_Config database was not in Single User Login Mode and are still faced with this error; I would recommend below post
Is your Sharepoint_Config_Log file reaching enormous GB size of data and nearing your full drive space utilization?
Shrinking a Log File in your SQL Database may seem very straightforward when accessing SQL Server Management Studio
You may have already tried the below and still not seen any change in the file size
If the above scenario is true, it is most likely that you have set your DB in Full Recovery Mode and hence will not allow you to shrink the log file
Please note that in my illustration I have made an assumption that the default dbname Sharepoint_Config has been changed; if changed please make revisions to the script accordingly
To confirm this further, run the shrink operating using the SQL Query.
From the SQL Server Management Studio
Your are most likely to get the below error
“Cannot shrink log file 2 because the logical log file located at the end of the file is in use”
In SQL Server Management Studio; run below commands
alter database Sharepoint_Config set recovery simple;
This will shrink the log file to its default size.