Date and time fields can have a default value of “Today” or “Now” that populates if you don’t enter another value in the field before saving an item. In your date/time column settings: If you choose type “Date only” you’ll get the current date If you choose “Date and time” you’ll get the current date […]
In your SharePoint form submissions and list items, sometimes you’d like date fields to be displayed a different way for workflows, notifications, views, grouping, additional metadata, etc. See video at bottom of post for an example use case and tutorial. Just create a calculated column (format as single line of text) in your SharePoint list or […]
The following is a DAX formula you can use to create a calculated column that shows “next year’s” value in “this year’s” row. You can easily adapt this to show “yesterday’s” amount or “tomorrow’s” total as well. It can be modified for days, weeks, months, etc. as long as the time measure is able to […]
I previously shared how to create a “Today” column in SharePoint that would always be up-to-date even if list items weren’t modified. These were no-code solutions that utilized either SharePoint Designer or Microsoft Flow. You can, however, use Today’s date/time to create views and calculated columns without workflow or script or the need to create […]
Since we can’t have an always-updated Today column OOTB, use Microsoft Flow to update a date column daily for use as a “Today” column in calculations.
Create a calculated column in your Power BI data source to correct time zones.
Learn an easy way to automatically remove Copy: prefixes from calendar event names, standardize location names and auto-delete canceled events taking up space.
Compare two dates in a calculation to get a result in years, weeks, days, hours or minutes. Use rounddown, roundup, concatenate and isblank to clean up your data.
Add a calculated column to your calendar that generates a clickable hyperlink to an .ics (or iCal) file that allows you to add the calendar item to your own calendar.