-
My IF Formula only works in certain cells in my grid
I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows: Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS…
-
SHow Availability based on Bookings
Hi I have two sheets, the primary is the booking sheet that has the event dates both start and end date, venue, client details etc. This would be my reference sheet. I have created another sheet that shows the availability of all the venues based on confirmed bookings per venue this is my Availability Sheet. Teh venue in…
-
highlight duplicate cells in each row
In a sheet, I want to auto highlight duplicates in a row so that it looks like the example below where I manually highlighted the duplicates. I want each row to be considered on it's own and highlight the cells in the columns that are duplicates. There are consistently two sets in each row. I don't want to remove them,…
-
Need Help with Latest Date Formula
I have a sheet where I need to identify if a parent/child record is Active. Expiration Date Is in the past or "N/A" Signed SpinCo Letter Include entries of "Yes" or "N/A" and do not include "No" or Blank. Contract Status Include "Executed" Here's what I have but I'm getting an UNPARSEABLE ERROR. =IF(AND(OR([Signed SpinCo…
-
Orders per day formula
I'm trying to be able to count the number of orders per day and a subset of that is number of specific part numbers per day. Is there anyone who can help me with this formula :) Thank you! David
-
Is there a best practice to convert a dashboard to a PDF?
I've been asked to see if there's a way to make saving a dashboard as a PDF more accurate. I've tried printing/saving as a PDF. Is there a setting so that the area that I have for a list can expand? If our area is too small, then we don't see the entire list. And if we make the area large enough to always contain the…
-
Formula not working - correctly
I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets. I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports…
-
How do I calculate End Date and End Time based on Start Date, Start Time, and duration in hours?
Would like to use the new TIME function, if possible. Working hours per day would be 24. Working days are all 7 days of the week. A task could span multiple dates, for example: Start Date = 6/26/2025, Start Time = 10:30pm, Duration (manual entry) = 3.75 hours. Formula(s) should result in End Date = 6/27/2025, and End Time…
-
Value Labels disappear on my chart Widget
When in edit mode, I choose to show value lables and looks fine. However, after I save the change, some of the values disappear. Is this a bug, or is there a setting I need to update?
-
Count Checkboxes Help please
Hi, I need to know the formula to work out how many check boxes are ticked under a parent row. We have 3 Teams - Team 1, Team 2 & Team 3 and I need to see how many Live Projects they all have as I am building a Dashboard. But in order to get the metrics on this I need to know how many live projects. I have a tick box under…