-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
linking two columns togther
Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe…
-
Locking rows already saved.
Is possible to locking some cells in a row after a collaborator saved? The collaborator will enter information in all cells in a row (this is why cannot be locked before been saved). After saving the information entered, some cells cannot be edit anymore but other cells can be add a value or edit. Thanks. Al
-
Formula to change RYGG balls when Project Stage changes
I am new to SS and I am trying to automate the Project Status Red, Yellow, Green & Gray balls to change to the correct color based on the Project Stage selected. Project Stage drop down will need to work as follows: Red Ball = Not Started Yellow Ball = Scheduled, Field Work, Drafting, Completed, Preliminary Sent Gray Ball…
-
Item Tracking
I am building an item tracking report with a helper column. There are 14 different items, and I want the helper column to post 1 (or anything it honestly doesn't matter what it posts) if it is the most recent action for an item for the purpose of building a report. I've got an autocreated time column and autocreated index…
-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…
-
SUMIFS with 2 criteria
Can't get the right formula for the task I want to perform - as follows - IF the PRODUCT column = "MMS", and the POSITION column = "CURRENT - CORE", then SUM the JAN'18 FCAST column basEd on the following range - JAN'18 facst19:JAN'18 fcast160 Latest formula version I tried is: =SUMIFS(JAN'18 fcast19:JAN'18 fcast160,…
-
A Sumif newbie needing help
Trying to write my first sumif equation and having a little trouble. Column Headers: Fabricator and Line Total If Fabricator: American* then sum Line total Here's my "formula" =SUMIF(Fabricator2:Fabricator40, =American*, [Line Total2:Line Total40]) Any help with be appreciated
-
Formula Help - 2 columns and % Calculation
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25%
-
Estimate End Date, Actual End Date, Adjusted End Date flagging
For my projects I track Estimated/Actual Start and Estimate/Adjusted/Actual End dates. I need to have a status flag indicate yellow if the Adjusted date is slipping past the estimated end date, and then when the end date is adjusted and justified, to update the status flag back to green. Is anyone tracking like I am? Do…