I have created a SharePoint list based on an excel list and now I'm trying to create a calculated column using one of the columns that was imported, but it seems that it's not possible. The imported column is a Date column, I have tried with a simple formula like: = Column1-5 but I'm getting the following error:
Sorry, something went wrong The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.
When I'm creating a Date column in the sharePoint list it works fine, but if the column is imported from Excel it's not working and gives me the error above.
Is there a work around for this?