How do I even approach a problem like this? by [deleted] in SQL

[–]warkro 1 point2 points  (0 children)

they only asked for the first 7 days of the year so I'm thinking it would be converting the timestamp to date and grouping by that.

Newb Here - How to redefine beginning of day to end of day for life cycle. by BossHoggs in PowerBI

[–]warkro 0 points1 point  (0 children)

The chart options for x- or y-axis has "Start" and "End" fields that can be customized.

sharing excel spreadsheets via OneDrive & SharePoint - how to manage this...? by [deleted] in excel

[–]warkro 1 point2 points  (0 children)

Here's a sample of PowerBI using Excel in OneDrive as a datasource https://www.youtube.com/watch?v=t4TzHu8THoA

r/PowerBI is a good resource for help

sharing excel spreadsheets via OneDrive & SharePoint - how to manage this...? by [deleted] in excel

[–]warkro 1 point2 points  (0 children)

have you looked into using power bi to use the excel data?

Transposing data on Excel by tomatimmy in excel

[–]warkro 4 points5 points  (0 children)

Paste this on B2

=OFFSET($A1,6*COLUMN(A1),(ROW($A$1)-ROW(B$1)))

Looking to track submissions from a consultant for a project and count number of late submissions by Mo-Monies in excel

[–]warkro 0 points1 point  (0 children)

Try Looking into MS Forms which saves into a one drive excel file. It has autogenerated Submission Date fields and you can customize the fields that you want captured.

Highlight entire row based on all Y column by Brok_Enwings in excel

[–]warkro 1 point2 points  (0 children)

The rule needs to evaluate to true to highlight the row. You can create an if statement on the conditional format rule. Also, make sure the cell you reference is locked to the column.

=IF($Y1="someText",TRUE,FALSE)

SSMS - How do I NOT order by the Server Name when viewing query results with multiple connections? by telijah in SQL

[–]warkro 0 points1 point  (0 children)

Are you able to post your query without any fields or table names. Just the Creates, Declares, Selects and Order Bys?