Tag Info

New answers tagged

2

In my experience, this level of complexity is when it's time to try something other than a single calculated column. You can nest calculated columns to do some subtotaling, you can make custom columns that do complex calculations in server side code, or you could have a powershell script come through and calculate the column. Any function with 11 closing ...


1

It'd be something like this: =IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Please Enter the SUID Only on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)) http://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx


0

Unfortunately calculated columns are calculated at the time they are filled in. Not each time the column is viewed. If you are, however, trying to do that calculation at the time the item is created you can use the following: =TEXT([Modified],"mm-dd-yyyy hh:mm:ss") A somewhat older but reliable article regarding time inside the calculated columns can be ...


0

The quick and dirty method is PowerShell and a scheduled task. Assuming your field is a date/time field. You can do any math you want in there as well. Just set it to run daily. $web = Get-SPWeb <Web URL> $list = $web.Lists["<List Name>"] foreach ($item in $list.Items) { $item["Current Date"] = Get-Date -format s; $item.Update(); }


0

other options: add Javascript to the view which updates the listitem using JSOM and But maybe you do not even need to update the Item, and all you want is a "today" calculation in the View, which can also be achieved with either CSR/JSlink code (which is not available in 2010) but can be done using Javascript in a Calculated Column (in both 2010 and ...


1

Two options Create a timer job which runs daily and updates the list items Create a workflow which fires daily and updates the list items Option 1 is straight forward and easy to implement. Option 2 don't require any deployment and you can use SharePoint Designer to achieve this, but building it is tricky.


0

You can do this by making LOSS column a Calcuated column. You can apply below formula =IF([Circuit Type]="ISDN",[N1]+[N2],IF([Circuit Type]="HDSL",[N1]-[N2],0)) The syntax is IF(condition, truestatement, falsestatement) In your case you can nest all the condition in multiple if's and use the falsestatement to specify else condition. Final formula will ...


0

Here is a post that has helped me in the past with very similar challenges. It has a hyperlink to an XSL document that contains several templates for date arithmetic operations. Hope this helps.


0

If you div by 864000000000 you will get Days. In order to get Hours you can use the same formula with div by 36000000000 and for minutes div by 600000000 ddwrt:DateTimeTick function returns the number of “ticks” since Jan 1 1900 ...



Top 50 recent answers are included