-
Sum based on status and Month
Hi I have the input and output screenshot as attach. How can I pull the formula to gather the sum of $ based on status for each month. Need some guidance. Thanks
-
Formula based on the date that a certain cell was modified?
I was wondering if it is possible to create a formula that changes one cell to a date when another cell was modified: I have two columns I want affected: 1) Status, 2) Closed Date. When the status is changed to "Closed" (it is a dropdown column), I want the closed date column to input the date that the status was changed…
-
How to reference a new row automatically when form is submitted
Hi, I'm creating a sheet that will reference a sheet with a form attached to it. If the person says "Yes", I'd like it to pop up in the new sheet with a web link. I've got it to work fine using an IF statement and referencing the specific cell, so it works with the specific row (Row ID 1). But I would like it to work off…
-
Hi, I am trying to get google maps to pick up on GPS coordinates is a cell.
I have the coordinates in two columns and using a formular to merge them into one. =[GPS South (If you know them)]@row + "," + [GPS East (If you know them)]@row I am trying to put this web link into formula above to make it a live link to google maps for the coordinates. Is this possible? Kind Regards Peter
-
I need to generate a report
Hi All, Myself vinoth, Im working on a manufacturing company which has three departments, i have total four sheets which is Main sheet, Pre sheet, foundry sheet, post sheet, each sheet has his own data like section status and their plan date, target etc, totally around 10-15 columns remain same for all the four sheets, we…
-
% Completion Formula based on drop down status
Hi there, Help needed! I need to report a % completion rate based on the status of a milestones column where a number of actions/milestones need to be completed in order for the formula column to indicate % status. Is there any formula that I could use to read the status drop downs, and auto fill a % completion rate in the…
-
Autogeneration of a column values based on other column values
Hi all, I am looking for a formula to generate values in one column based on multiselect dropdown options in another column. I have a column named "Interests" with a multiselect dropdown options "Quality", "PIM", "Micro", "CSF", "Leukemia", "Histology" and "Tumor". Now, I have other column "Department" which should be…
-
Count formula pulling from multi select
Help! I need a formula that will calculate the total # of times a department is listed within a multi select column. Scenario: Sheet "Project Plan" has a "Department(s)" column listing MEQA and Strategic Ops. Sheet "Status Totals" where I want to build the formula
-
checkbox formula for last 30 days
Hi, I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me: If the date in the date column (row@cell) is in the last 30 days then checkbox.
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…