Hi community, I'm attempting to find a formula that will return the parent row where the end date is equal to the current week. I have created a helper column that calculates the current week number. …
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system colum…
I want to be able to see a view of all my staff with their associated tasks across all projects. Currently the Resource View does this except it does not label the tasks, it simple shows allocation pe…
I have a sheet with a dropdown column for priority: High, Medium, Low. My sheet sorts them according to the order specified: High, Medium, Low. However, my report sorts them alphabetically: High, Low,…
Is there a method to have a report that generates past due tasks? On our task management sheet, I have a ‘due date’ and ‘date completed’. Once a task is finished, my team members will input the date c…
Hi, We have a lot of reports, they have only small differences. Normally it is just a filter e.g. name of "assigned to". If we have to slightly change these reports, we have to change all the reports …
Hi I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not su…
I need to change column header names on a sheet which is going to break reports. How can I identify all locations that the data field is used.......reports, metric, etc.?
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every …