-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Nested Criteria error only for one row
Hello Community, I have a column formula that works fine for every row except one. This particular row is not any different that I can see from the others. I apologize for the length of the formula, I will do my best to isolate and breakdown the issue I am having: Here is a pic of a test column created to work out the…
-
Should I use INDEX/MATCH Instead?
On sheet A I have a date, if it falls within 2 dates I want to display a PROD date from another sheet. I can get IF/AND working =IF(AND([Testing End Date]@row > DATE(2021, 10, 1), [Testing End Date]@row <= DATE(2021, 10, 27)), {Build Release Plan Range 1}, IF(AND([Testing End Date]@row > DATE(2021, 10, 28), [Testing End…
-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
COUNTIFS Formula not picking up additional rows
I created a COUNTIFS Formula to tabulate results from a column containing responses from a Multi Select Drop Down Form. Once I go the formula right, it calculated correctly but as additional rows have come in to the sheet, it isn't picking up those additional rows. One cell is still showing the original value, though based…
-
Nested if statement not working, am I doing the formula wrong or is it not working correctly?
Hi all - I am trying to do a nested if statement for an approval chain but I can not get it to return a value different than #UNPARSEABLE. Can someone check my formula and tell me where I am going wrong? =IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes",…
-
Nesting IF Formulas & Status Change
I'm using a sheet to track status of contracts based on their expiration dates. The formula below is what I've set up to try to show that I want the status to be GRAY for no expiration date, RED if the contract has expired, YELLOW if there are 30 days or less until expiration, and GREEN if there are more than 30 days until…
-
Using Countifs in differents sheets and related with 2 columns
Hello everyone! I need some help. I'm trying to match a two formulas for each column, similar like these, |In Progress| =COUNTIFS({Progress}, <1, {Start}, >=DATE(2021, 05, 1), {Start}, <=DATE(2021, 05, 30)) ---- Result should be "2" since there're 2 dates in the column finish date with the month on May. (It should be…
-
How to use a value in AVG that is selected from criteria
Hello! Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet. Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA})) Objective: To pull in a value to be averaged for all Level 1…
-
Pull Items from another sheet set for earliest date
I'm fairly new to SmartSheets and have been trying to figure out how I can pull items from my master list to show what is set for the next launch. Here is an example of my master table I want the new sheet to capture a different row for every enhancement in the example it would grab. A,C and E. Any help would be greatly…