Formula problem
-
Hi, I'm new to Sharepoint and have a problem with a formula to display different messages in a column. I have a column named Version that contains a files version. If the version is 0.x I want Draft to displayed in another colummn, if version is 1.x display Revision 1 etc. This is what I have now, and as you probably understand it doesn't work. :^)
=IF(ISNUMBER(FIND("0.",[Version])), "Draft", OR(IF(ISNUMBER(FIND("1.",[Version])), "Review 1"), OR(IF(ISNUMBER(FIND("2.",[Version])), "Review 2"), OR(IF(ISNUMBER(FIND("3.",[Version])), "Final"))))) -
Hi, I'm new to Sharepoint and have a problem with a formula to display different messages in a column. I have a column named Version that contains a files version. If the version is 0.x I want Draft to displayed in another colummn, if version is 1.x display Revision 1 etc. This is what I have now, and as you probably understand it doesn't work. :^)
=IF(ISNUMBER(FIND("0.",[Version])), "Draft", OR(IF(ISNUMBER(FIND("1.",[Version])), "Review 1"), OR(IF(ISNUMBER(FIND("2.",[Version])), "Review 2"), OR(IF(ISNUMBER(FIND("3.",[Version])), "Final")))))Hello, Sharepoint formulas use the same syntax as Excel so you would have to nest your IFs to get the effect you want i.e. =IF(Criteria, Result, IF(Criteria, Result, IF(Criteria, Result, IF(... so your formula would look something like: =IF(ISNUMBER(FIND("0.",[Version])), "Draft", IF(ISNUMBER(FIND("1.",[Version])), "Review 1", IF(ISNUMBER(FIND("2.",[Version])), "Review 2", IF(ISNUMBER(FIND("3.",[Version])), "Final",""))))
-
Hello, Sharepoint formulas use the same syntax as Excel so you would have to nest your IFs to get the effect you want i.e. =IF(Criteria, Result, IF(Criteria, Result, IF(Criteria, Result, IF(... so your formula would look something like: =IF(ISNUMBER(FIND("0.",[Version])), "Draft", IF(ISNUMBER(FIND("1.",[Version])), "Review 1", IF(ISNUMBER(FIND("2.",[Version])), "Review 2", IF(ISNUMBER(FIND("3.",[Version])), "Final",""))))
-
Hello, Sharepoint formulas use the same syntax as Excel so you would have to nest your IFs to get the effect you want i.e. =IF(Criteria, Result, IF(Criteria, Result, IF(Criteria, Result, IF(... so your formula would look something like: =IF(ISNUMBER(FIND("0.",[Version])), "Draft", IF(ISNUMBER(FIND("1.",[Version])), "Review 1", IF(ISNUMBER(FIND("2.",[Version])), "Review 2", IF(ISNUMBER(FIND("3.",[Version])), "Final",""))))
As said, the formula is working now, but.... When a file is changed, new major version etc, the formula returns blank. If I go to library settings > choose the column and saves again, without changing anything, it shows correct values in the column again. Why? And what can I do about it?
-
As said, the formula is working now, but.... When a file is changed, new major version etc, the formula returns blank. If I go to library settings > choose the column and saves again, without changing anything, it shows correct values in the column again. Why? And what can I do about it?
Hello, I wasn't aware of the issue, tbh, but it would seem that system columns such as Modified, Version etc. get updated after the content of your list or doc lib. which is what's screwing your calculated column up. When you edit and resave your calculated column it performs the calculation again which is why you get the correct result again. If I can get to the bottom of it I'll post a fix/workaround.