-
First Month's Date Range
Hello, I'm looking to get a response like this: 07/01/23 - 07/31/23. I want to get the previous month's range based on the values in the column (The previous month could potentially have entries dating 9/1/23-9/25/23, for example). I am referencing another sheet's column {REF DATE}. Dates range from 7/1/23 to 8/2/23 at…
-
Workload Availability
Is there a way to be able to calculate employee workload based on the estimated hours per task considering that each task has a very different timeline. I have the field of estimated hours for that time period, hours for each task. In the end I want to see if they are exceeding their work hours for that particular period.
-
keeping information current / between two sheets
Hi, I have several worksheets, one being the master. I have figured out how to "copy" a line from one to the other, but when that line changes, it does not update the other sheet. How do I ensure the two stay in sync? as an example - in the secondary sheet, the line changes from planned to completed, but that change is not…
-
Comparing one multi-select field against another
Hello Community! I wonder, is it possible to compare one multi-select field (array) against another and return TRUE if any match can be made between the two? Consider the following data set. Currently, I am playing around with: JOIN(COLLECT(Print:Print, MultiSelectData:MultiSelectData, {Returns True When ANY Match…
-
How to reduce the frame of a report on a dashboard
Hello community.... I was wondering whether anyone has had experience of reducing the size of the view in a report on a dashboard (no, I don't mean by dragging the corner to make it smaller 🤣) I want to show my report, but hide the title bar. E.g. the below image would only show number of racks and amps. Any ideas /…
-
Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
-
Formula for countif and contains
I am having trouble creating formula that adds two fields. The first field must contain the word strategy, and the second field can be one of several status. Here is one attempt of the formula: =COUNTIFS([Project Type]:[Project Type],CONTAINS("Strategy", @cell), AND(COUNTIFS([Project Phase]:[Project Phase], “Execution”,…
-
NETWORKDAYS WITH AN IF??
Can anyone help with a formula to track the number of days between 2 separate columns with the IF of stopping the count once a date is populated in one of those columns?
-
How to add two Countifs that are pulling information from two different sheets
Hi Everyone, I am trying to create edit a function to include another Countifs statement and add them up however I am unable to get this to work. I have tested out one of the separate countifs functions and know it works independently to count. Any help on how to combine the two and produce a total number would be…
-
Incorrect result for NETDAYS and NETWORKDAYS formulas
Hi everyone - would appreciate any help with this. I am trying to calculate both the net days as well as working days between today and a start date. My formulas are working....kind of. I'm not getting an error, but the results are incorrect (per other countdown sites and google). So if I should get 203 days I'm getting…
