-
Convert to Column Formula option is missing from my menu
Hi, I'm the Admin of this sheet, but when I right click on the Formula column, I don't see the option to 'Convert to Column Formula' in the menu. Am I missing something?
-
Help with SUMIFS formula
Hi All The below formula is is returning incorrect argument and i can't figure out why =SUMIFS([Column10]@row :[Column14]@row , [Column10]4, [Today's year]#, [Column10]3, ">=1", [Column14]3, "<=6") I would be very grateful for your help as I appear to be missing something simple?
-
How to calculate sumifs across multiple columns
Hello community! I am trying to build a summary worksheet to get an overview of all the meeting categories but my raw data has multiple data columns and the formula I am using comes up as an error Summary sheet Raw data I need to get a total sum from both "no. of meetings chaired by CPO" and "no. of meeting attended as a…
-
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…