-
Remove Rows That Are No Longer In Report
I've done a little bit of research and from what I'm seeing there isn't a way (but I'm hopeful you all have a workaround 😀). So I have sheets that contain multiple unique IDs for tasks (they are separated out by manager since we have so many of them) and if a task is deleted on a project plan because it isn't needed…
-
IF/Index/Match
It's Monday and I can't seem to get this one to work. If a value populates in a cell in a specific column (this is a formula column) Every row that contains this data (All the columns) it would fill in the data that's listed in the formula column.
-
IF/OR Formula
Hello - I am trying to make a formula work but having issues. I have a more significant formula that is correct but when I add to it, I mess it up and can't figure out what I'm not doing. I can make each formula work on its own but having trouble merging them. The following formula works. I need all of it but I also need…
-
If match formula
Hello! I'm trying to catch if there are any discrepancies between model homes on our manual entry vs the systems data. Model homes should be based on whether ADA is required or not. I've already created a helper column that tells me if model homes don't match but I need to add the "ADA Required?" column to my formula and I…
-
Calculating a Total Occurring within a Specific Month (SUMIF)
Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't calculating either! I've tried it with and without the parent/child indentation and same result. I want to calculate the total…
-
JOIN COLLECT with OR criterion?
Hello community, I am trying to put together a JOIN COLLECT formula with a criterion whose range is a multi-select dropdown menu. Right now the formula is working when only one is selected from the menu. =JOIN(COLLECT({ERT Emails}, {Status}, "Active", {Region}, Regions@row), ", ") How can I adjust the formula to pull from…
-
How to make my automated email only send once?
Hello! I am going to explain as best I can. So i have a automated system setup and currently i have where they fill out a form and it then auto creates a Fillable PDF. That gets sent to them which they have to get signed and re submit it into smart sheet. I have it set up where it send an alert which has the PDF and then a…
-
How to remove NA from Calculation
Hello, I am currently using the formula below to get a percentage complete calculation, one of the parameters has the option for NA. How do I include the NA in the formula to make it so it doesn't affect the percentage? It is the bolded parameter below: =SUM(IF([Paperwork Received]1 = "YES", 0.2, 0), IF([Samples Received]1…
-
COUNTIF or COUNTIFS to sum blank fields
I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been able to get a formula to work when trying to account (and not count) for the helper columns (in this example column 11 and…
-
Expense Sum Formula
I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today. I have tried many variations of the following and it's still Unparsable. I've also tried adding @cell. What am I missing? =SUMIF([Event Title]:[Event Title], "MS CI…
