-
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…
-
Please Help!
I'm creating a CRM, I have 2 columns. One is the Sales stage with column properties (drop-down list) and the other is a probability% column with drop-down options. I want a formula that will add the percentage from the drop-down options based on the sales stage that's selected. Example if '1. Not Qualified' is chosen, I…
-
How to copy a sheet without updating system generated columns Created By and Last Modified By?
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the new sheet get messed up because many columns contain formulas that extract the data…
-
How to get a lookup (Vlookup or Index Match) to return multiple values?
I'm essentially trying to have one cell populate with text values from multiple different cells based on a certain criteria. What I really wish I had is a JOINIF function, if that explains my problem better. Thanks in advance!
-
Date Calc Not Working
I feel like I am going crazy here.... I have a formula in the first column (formatted as a number) to take 04/27/22 and subtract 04/17/22 (both columns are formatted as date columns) but the result is 14? When I take the 04/17/22 and add that same cell of "14" I get 05/01/22. Has anyone else run into similar issues when…
-
INDEX COLLECT or VLOOKUP not working with numbers
I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference sheet. Here is what I have tried. =IFERROR(INDEX(COLLECT({Tenure }, {Employee Number},…