Getting requests from user to modify the list view of a list.
So I started looking around for what we had already done in the past.
I did a simple calculation of field and spent time fumbling around with the syntax.
User wanted a the result to display a date in the future based on two other fields.
If either one of the dependant fields was blank then the result should be a blank.
This was the solution for that column
=IF(AND(ISBLANK([FieldDate]),ISBLANK([FieldLengthOfTerm]),"",[FieldDate] + [FieldLengthOfTerm])
Of course, the more features you provide the greate the requests become. Never fear the
KPI graphic look can be provided based on Alexander Bautz's post:
http://spjsblog.com/2011/11/29/compare-date-with-today-status-indicator-in-list-view/
No comments:
Post a Comment