#Office365Challenge Yes I know, limitations again. But rather the devil you know… So let’s look at what you can’t do with calculated columns.
|Day:||284 of 365, 81 left|
|Tools:||Office 365, SharePoint|
|Description:||SharePoint Calculated Column Limitations|
- Day 275 – SharePoint: Hide error values in calculated columns
- Day 276 – SharePoint Calculated Field Formulas – add days to dates
- Day 277 – SharePoint Calculate difference between two dates
- Day 278 – SharePoint Using ABS Function
- Day 279 – SharePoint Show dates as days of the week
- Day 280 – Calculate the Average of numbers SharePoint
- Day 281 – ROUNDUP, ODD, or EVEN functions in SharePoint
Just a quick reminder on which columns are and which are not available in Calculated Columns:
|Columns Available||Columns NOT Available|
|Title (Single Line of Text)||Multiple Lines of Text|
|Single Line of Text||Person or Group|
|Choice||Hyperlink or Picture|
|Number||Other Calculated Columns|
|Currency||Managed Metadata (Term Store)|
|Date and Time||Created By (Person)|
|Yes/No||Modified By (Person)|
Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.