New answers tagged calculated-column
This sounds more like a timer job should be made - that way the job can be managed via Central Admin. A workflow might work, but a timer job is more likely the correct way to update a field on a schedule.
Interesting friday evening challenge.. I took a completely weird approach process every row (when displayed) store the High, Low , Total and Average value on the body tag for every row done (they proces async) calculate the 3 segments (low,medium,high) between the Low Values calculate Average, match with low,medium,high color and color the Table (4 ...
I created a column - "Creator" - Person/Group In the sharepoint designer, I made a "When new item is created" workflow to update the "Creator" as "Created By".
Caluclated Columns will be calculated each time they are displayed. You don't have to update items. :-) The problem is your formula. Why do you try to convert it to INT? SharePoint has very nice Calculated Field Formulas, see http://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx A working example would be: ...
You're using TEXT, which makes it un-sortable. You'd have to be using =DATE(MONTH(Modified),DAY(Modified),YEAR(Modified)) or similar. I doubt you can get the behavior you're looking for with the 'long month' without setting all your dates to this format (regional settings).
You can still sort by the Modified field, which is indexed and very well suitable for sorting.
Similarly, I was asked to set a field as the "Second Thursday of Next Month." Using this post as well as some other tricks I already know, I was able to come up with a formula (shared if other users get the similar request): =DATE(YEAR(Today),MONTH(Today)+1,(5-MOD(WEEKDAY(DATE(YEAR(Today),MONTH(Today)+1,1)),7)+8)) Because you aren't adding the values to ...
In english version of SharePoint it can be done with this: =MID("Hello(ABC)", 7, 3) There is a nice article: http://yalla.itgroove.net/2012/09/sharepoint-calculated-column-formulas/ A dynamic version would be =MID("Hello(ABC)", SEARCH("(","Hello(ABC)")+1, SEARCH(")","Hello(ABC)")-SEARCH("(","Hello(ABC)")-1)
Top 50 recent answers are included