-
How do I write my SUMIF formula so that it automatically sums numbers in its own column?
All -- I am putting together a SUMIF function for Column Beta that adds together only those column entries whose Column Alpha have a specific value. This gets me: =SUMIF(Alpha5:Alpha56,"Value",Beta5:Beta56) According to the Help & Learning article on SUMIF, the "Beta5:Beta56" part of the formula is called the "sum range."…
-
Duplicate Helper column with filter
Hi! I'm trying to build a formula where I search for duplicates within one column (Job Numbers) but only if "Invoice" has been selected in another column (Deliverable Type). I was able to get a formula to search for duplicates working but it is searching all the deliverable types, but I just need to know if there is more…
-
How could we convert the day to year?
i have tried to number of days divide by year, seems not working
-
How to use If and and?
I have 3 columns A, B, C I need to write a formula that will return Column C based on the values of Column A and Column B. If Column B=3 AND Column A is between 3.5 & 4.4 then return 4 If Column B=2 AND Column A is between 3 & 3.4 then return 3 If Column B=2 AND Column A is between 3.5 & 4.4 then return 3 I am able to…
-
Countifs Formula Referencing Another Sheet
I could use some help with a formula that references another sheet. The sheet I want to reference is titled: Certified Roster Status The sheet has a number of columns. But, there are two columns for which I want to use the criteria for the count. I’d like to get a total count from the column called Status when the word…
-
JOIN & CHAR and blank cells
Hi - I am joining cells in a row that may or may not be populated with data. I need to pull them all into a single cell to map to a document. I've managed to pull them all in using this formula: =JOIN([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, CHAR(1)) The issue happens with mapping. When a cell in the row is…
-
How to count within date range by name of event and name of employee
Hopefully I'm asking this correctly. I need help with a formula to count the # of events an employee managed by event type and within a date range. Example below: Date Column Name: Event Scheduled Employee Column Name: Employee Employee: John Event Column Name: Event Type Event: Birthday I would like to count how many…
-
Formula for business days
Hi! Is there a way to do a formula calculating a date plus x no. of business days. For example, I need 7 business days from the time something was approved. Right now I have =[APPROVEDDATE]1-7. But this is giving me the date 7 calendar days from the Approve Date. I need it to give me 7 business days from the Approve Date.…
-
Formula ideas
So here goes; sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN} Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??
-
Percent Complete Plan Formula
Smartsheet Community: I am Tracking Plan VS Actual and have a % Complete Formula to Track The Plan. However, My Formula is at 100% Complete for Plan, but the due date is 11/28/22. Therefore, it should be Calculating 100% Complete as of Today. Does anyone have any idea where in my formula is incorrect? % Complete (Plan):…