-
Looking for a formula to show the current status
I have created multiple approval workflows and wanted to update the current status in the Status column using a formula,
-
SUMIFS + range + criterion_range between 2 dates
Hello, community, Struggling with a SUMIFS formula. I've created a metric sheet to sum a specific column (E) in a project sheet by month. The column lists quantities for each mission (only at the parent row for each mission), spanning different months and years. While a simple SUM formula for the entire column gave the…
-
Can i get get help with a date formula please?
Hi team, what is the formula to auto populate a date based on another date? ie "date 1" equals 7 days after "order date"?
-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
Multiple checkboxes in one cell - Formula for True (Part 2)
This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and…
-
SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0
Hi can anyone see if they can think of what might be causing this formula to compute 0 and not Summing the {Check In Log Range 1} {Check In Log Range 1} = Dollar Volume {Check In Log Range 2} = Employee Condition {Check In Log Range 3} = Start Date {Check In Log Range 4} = End Date =SUMIFS({Check In Log Range 1}, {Check In…
-
Is there a way to have completed tasks in a sheet either obsolete or move to the bottom of sheet?
Is there a way to have completed tasks in a sheet either obsolete or move to the bottom of sheet after a certain amount of time has passed?
-
How to change my formula to flag yellow on due dates instead of red.
I believe this is an easy fix, I am just not able to figure it out! I am trying to change my formula so that the status icon does not change to red only once it is in progress for tasks due today. I would rather it show as yellow if something is due today, then red if it passes its due date. Here is my current formula:…
-
Help with IF, THEN
I want a calculation to run if a cell value is within a range. IF Cell X is between 1-4, THEN sum(cellZ, cellP, cellH) How do I write this?
-
Can we safely use cross-sheet references in column formula?
Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and the column that gets updated displays region based on the country code (EMEA, LATAM, NA, etc.). I decided to create another…