Timeline for sharepoint 2013 calculated column brackets disappear
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 16, 2014 at 17:00 | answer | added | AhuraMazda | timeline score: 2 | |
| Jan 16, 2014 at 16:32 | comment | added | AhuraMazda | ok,id is a default id not a created column. here is my result imgur.com/35a3bRw . first column is id(which is sharepoint generate automatically) and last column is id2. | |
| Jan 16, 2014 at 15:09 | comment | added | Pepozzo | And if you try to modify an existent item? However I've tried to add a new item with your formula (and even with ID column as text or number) and it works fine. Could you please attach a screenshot of your problem? Thanks PS: here's my test results imgur.com/fgfkogc | |
| Jan 16, 2014 at 14:28 | comment | added | AhuraMazda | thanks, i want to do second one. i want to substract 200 from ID number. althought formula works for the old items, new items cannot take the formula correctly. this is because of that formula changes and brackets gone. | |
| Jan 16, 2014 at 14:02 | comment | added | Pepozzo | Ok, it's normal that SP converts squadre brackets. I can't understand what you exactly want. If your need is the ID2 should have the starting digit as 1 or if you want to subtract 200 to ID field. Anyway, if your need is the second one, your formula seems right, otherwise the formula should be: =IF(ID>200;"1"&ID;"OLD ID") | |
| Jan 16, 2014 at 13:51 | comment | added | AhuraMazda | yes i insert it manually. formula looks like "IF(ID>200;ID-200;"OLD ID")". i want that, if ID bigger than 200 then ID2(my new additional id column.) shows the id2 number with beginning number 1. | |
| Jan 16, 2014 at 13:44 | comment | added | Pepozzo | Are you inserting ID field manually, right? What do you mean with "changed formula"? I've tested your IF formula in a SP 2013 list and trying to add new item with ID<=200 it returns "OLD ID" otherwise it returns ID-200, so it seems working. | |
| Jan 16, 2014 at 13:33 | history | asked | AhuraMazda | CC BY-SA 3.0 |