Strange issue with calculated column containing dates
Dear all, I have an SP list with a date column ("Expiry Date)" and a calculated text column with: =IF(ISBLANK([Current Contract Expiry]),"No Expiry Date",IF(Today>([Current Contract Expiry]),"No","Yes")) The issue is that the formula does not seem to work in some cases only. E.g.: date is 31/07/2020 sometimes gives "Yes", sometimes "No". If I change the date to sometime else and then back it seems to work, but I need to make sure I understand why this is happening to avoid it in the future. Any ideas? Thanks, Max
SPFx Field Customizer - Display totals for calculated columns?
Hello, since I found no way to employ custom column formatting with JSON, I wanted to ask if the following is possible with field customizers before I dove deeper into this. Can a solution be created that displays the sum of a column like this? https://i.stack.imgur.com/B7O5r.png I've not found any solution or code that would work in modern libraries, only in the old UX. https://sharepoint.stackexchange.com/questions/148496/displaying-sum-value-of-a-column-in-some-other-place-in-the-page https://sharepoint.stackexchange.com/questions/218102/june-13th-2017-microsoft-blocked-handling-html-markup-in-sharepoint-calculated-f/218110#218110 Thanks for your answers.
