-
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…
-
Ability to concatenate down to the HH:MM:SS
I've concatenated cells (in Figure 1) by using the formula in Figure 2 (MM stands for Month in my formula), which gives me a viable date (see Figure 3) to work with in SS. However, I want to go down to at least the minute. Is there another formula that can reach down to the hour & minute, or is (DATE(YYYY,MM,DD) the only…
-
Trouble using cross reference formulas
I've been using multiple sheets and cross-reference formulas for about 3 years. Suddenly today, the cells aren't populating?? For example: =IFERROR(INDEX({TBMB Booking Account Executive}, MATCH($[Auto#]@row, {TBMB Booking Auto Number}, 0)), "") This used to display the contents of a cell from another sheet if it matched a…
-
Index and Matching Formula Help
I am trying to make a formula that looks in a column on Sheet A which is a drop down containing all values from a column on Sheet B, finds the match, and then looks in the row in Sheet B where the match is found to find an additional piece of information and pull that back into sheet A. I am thinking I need indexing and…
-
Project critical path filter
Hey, We already have a native way to highlight a project's critical path: But is there a way to implement a filter based on this criteria? I would like to be able to run a portfolio level report to show me all critical paths across projects. Thanks for your help, Matt
-
Multiple contact list cross linked with a single choice list
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
-
Filtering Graphs in Dashboards
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
-
Approval Date to Completed/Archived Date Duration
On one sheet we have the Approval date column - this records the date as to when the project was approved. Then there is another column that records the date when the line gets moved from the active projects list to the completed/archived project list. A date will not be filled in until this time. Is there an easy formula…
-
Can an if statement be used with index collect? Looking for value on two different sheets.
Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…
-
Table View - Show column links AND formula in row header
Currently, if there is a formula in a column and the data is part of a column link where that formula data is being sent elsewhere, the column only shows the Column Link icon… and doesnt show the formula icon. It gave me a minor heart attack today!!