-
My SUMIF formula stopped working and I don't know what's wrong!
So I have this formula and it was working fine, but I updated the sheet with new people - new names in the intern field and so changed the formula to align with the new names. Now it's showing as an Operational error, but I have no idea what's wrong - anybody have an idea??
-
How to set up move row automation with formulas
I currently have a formula in place to "star" a row on sheet A when a unique identifier # from sheet A is added to sheet B. Then, I would like to move the row from sheet A to sheet C after the "star" is highlighted. I read the statement below in the smartsheet Automation article: "Actions that will automatically modify the…
-
Changing Primary Columns
I have a number of smart sheets that all 'talk' to each other, and feed various dashboards and reports. Slight problem in that the primary columns across them all are different - partly an oversight when setting them up, partly due to different people in the organisation setting up different sheets which I have since…
-
At Risk Flag
Hello, Based on example from sheet provided, I'm looking for formula to populate in the At Risk column to flag as At Risk if Final Due Date is seven days out and the Status does not equal "Yes" and % Complete is not 100% Any support is appreciated!
-
Between Dates Formula Referencing Another Sheet
I have two sheets I am trying to tie together. Here is the scenario: Sheet 1 (Below): Has the city reference. Current Rent is where I am trying to type the formula. Idea is to return the current rent based on today's date and the city. Sheet 2 (Below): Has the rent schedule range and the city to reference. There will be…
-
How to add a value from any row that has column = May
This sheet (displayed to users as cards) moves projects to different months for capacity planning. We then have a header task for each month which we display the total job value currently assigned to the month. This value is currently manually calculated. How/can we have a formula in the header task that sums all the $…
-
Ignore Summary Task When Counting Late Tasks
I use the formula when counting late tasks: =IF(ISBLANK(Finish107), "", IF(AND(TODAY() > Finish107, [% Complete]107 < 1), 1, "")) The issue with this is that it also counts summary tasks which really aren't tasks themselves. Is there a way to ignore summary tasks so I don't have to manually delete the formula in the cell…
-
Why is a simple division formula not working?
I am trying to divide two different cells into another cell. I am taking my information from my quantity column (qty3) and my rate column (rate3) and divide them. I want it to look like this =QTY3/RATE3 but it always comes up #INVALID OPERATION. I also changed the symbol to addition and it did not add the numbers…
-
Conditional cell linking?
Is cell linking based on conditions possible? I can't think of any other way to get the data pulled to another sheet that I need. I need a specific value pulled from one sheet to another if 2 conditions are met. I assumed and IF/AND statement would just pull the value I need, but I get an error. I'm drawing a blank on how…
-
Status Updates
Good afternoon gurus! Here is our question of the week! I have a process that follows a material through different stages of release. This process spans across multiple sheets, some sheets containing multiple steps in the process. I had a "status" column requiring manual updates, but time has shown that automation would be…