Hot answers tagged calculated-column
The problem is that calculated columns don't recalculate until an item is modified. So if nobody edits an item for 3 days after post-op, your calculated column will still show 0. You have 2 options within SharePoint: either show the op date and let your users calculate it in their heads, or create views that filter into 0-1 days post-op, 1-2 days post-op, ...
As Aron mentioned if you wanted it to automatically update you'll need to configure something to periodically update the values. Some options: A SharePoint Timer Job that runs once a day to update the column. A PowerShell script to update the column that runs once a day via the Windows Scheduler.
=IF([Column A]="aaa",(IF([Column B]="bbb","12345","It's not good!")),"It's not good!") You can test SharePoint calculated columns in Excel by substituting the column names for cells. I tested this on a list and had successful results. Column A & B are both Single lines of text with C being the calculated column. Are you getting an error message or ...
If you want to have only one calculated column where all the conditions, you must put next condition in statement else previous conditions. For you conditions example: IF(Service="ACB",(IF([Fac/Fellow]="Faculty","002701284","")),(IF(Service="Surgery",(IF([Fac/Fellow]="Fellow","002701294","")),"")))
Only top voted, non community-wiki answers of a minimum length are eligible