User Profile
dreaves996
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
I can't edit excel online file in document library
We have an excel document saved to our SharePoint Document Library and for some reason I'm unable to edit the document. My permission is set to Full Control for the document library. I'm able to edit the other documents in the library but this excel document. For some there's this read-only, no edits icon that appears next to the document name. How can I re-gain the ability to edit the excel document.Calculated Column return wrong value
Hey All, I have a calculated column that returns a total after information has been entered into a SharePoint list. For some reason it's returning the wrong number. Here's the formula:=ROUND(SUM(([Breakfast In Town]*10)+([Breakfast On the Go]*6)+([Lunch In Town]*15)+([Lunch On the Go]*10)+([Dinner On the Go]*15)+([Dinner In Town]*25)+([Misc. Expense Amount])+(IF(AND([Flying or Driving?]="Flying",[Rental Car?]="No"),([# of Travel Days]*15),"0"))+(IF([Flying or Driving?]="Flying",([# of Travel Days]*10),"0"))+(IF([Rental Car?]="No",(([Distance Driving]*2)*0.575),(([Distance Driving]*2)*0.2)))),-1) When I test it. I entered "Flying" for the [Flying or Driving?] column, "No" for the [Rental Car?] column, "1" for the [# of Travel Days] and 0 for the the other columns. For some reason my total came up to $30 when it should of came up to $25. What may I be doing wrong?
