Yet Another Conditional Formatting Query
Hey folks, I have an SP list with 3 relevant columns - IssueDate, ReviewFrequency, and NextReview. IssueDate is for manual date entry, ReviewFrequency is a choice of N/A, 3, 6, 12, 24, 36. NextReview is a calculated column that adds number value in ReviewFrequency to IssueDate. I have applied JSON formatting in Format View to format rows where NextReview is less than today (@now) in sp-field-severity--severeWarning, rows where next review is due within 30 days (2592000000ms) in sp-field-severity--Warning, and all other rows in alternating sp-css-backgroundColor-BgLightGray30 and sp-css-backgroundColor-noFill (giving zebra alternate banding). All works well apart from an issue with dates being read by conditional formatting as MM-dd-yyyy not dd-MM-yyyy as illustrated here: How do i ensure dates in the columns are seen / interpreted as dd-MM-yyyy in the conditional formatting rules? Thanks in advance,
How to create a rolling calculated column in sharepoint list
Hi- first time posting here, and new to sharepoint. I have a sharepoint list in which i have some basic calculating columns totaling hours and units worked on a day's shift per employee. I was looking for some insight, if a calculated column could be made using a rolling time calculation for instance towards a payroll date. This will allow me to group all entries by a pay date. payroll is sent out on the 15 & 30th of every month. I plan to have this sharepoint list as a data source into power bi & /or excel i can easily group the employee's total per pay period and have it vlookup again a payment table. However if i can group by a payment period that would greatly impact my over all goal. Thank you for taking to time to review my question Drew WestmanDate Interval - get each day´s date for a flow run?
I have a problem with how i use a flow. My users report a start date and an end date to a sharepoint list. Then i post a reminder of todays events and tomorrows event into Teams. But if the user have entered a date interval of 3 days, the flow only picks up the startdate column data. How can i force sharepoint to create a row for each day in the date interval? For example, user answer my Microsoft Forms and enters startdate and enddate of their event. but then i want to remind in teams about this event every day, not just at the start-date. I want a reminder each day. So if the date-interval is 10 days i want one reminder every day. How to get the date for each day in flow? Or if i could build a flow that breaks down a date interval and adds a row for each interval and use that list to pick out reminders like i do today. Acutally that would be the best solution, i got the reminder flow running now, it works fine. If i just could point that flow to a list containing all dates in a date column, it all would be solved. How to break down a ten day interval so that each day get it´s own row startdate, date2, date3....date9, date10 (one for each row).
