Hi is this possible in sharepoint 2013 formulas?
automatically add new list item if the Column has a value and adds a new value "1" in calculated column that's newly created
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Can't be done using formula, but you can do it using workflows. Create a SharePoint Designer workflow to achieve what you are looking for.
Never say Never...
Drawback is this is only triggered when the Calculated Column is displayed in a View. But from a Form you end up in the default ListView page by default.
Another option is to use CSR (Client Side Rendering) code on the New and Edit Form which triggers the JSOM code, that way no Calculated Column is required.
You have a bit of a challenge here.. as the Item you are working on does not exist yet in the database.