-
Help on formula: Nested ifs
Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (these are the subtasks) because of any of the listed reasons, it will be reflected in…
-
IF Function
I want to create an IF condition where if a cell contains a symbol on another sheet that equals "New" then populate that value otherwise, leave it blank. I have this formula: =IF({New Applicant(s) Range 1} = "New", {New Applicant(s) Range 2}) According to what I've read in the HELP, the False condition is optional and if…
-
Tracking latest Changes for Helper Column
Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team leaders will update the row with the current production number at every interval. I want to have a helper column that will…
-
Exclude blank "Due Date" cells from formula
I'm trying to update my "At Risk" column (Flag icon ON/OFF). I want to create a nested formula. I want the flag ON if all three conditions are met: * The "Due Date" is within one day. Example: if today is 2018-05-04 and the "Due Date" is 2018-05-03, then this condition is met. * I have a "Status" column. If one of these…
-
Do Not Count Holidays and Less than Zero
Could someone tell me how to write this Excel formula for Smartsheet? Excel: exclude holidays and leave blank if date completed is empty. =IF(NETWORKDAYS(E2,G2,Holiday)<0,"",NETWORKDAYS(E2,G2,Holiday)) Smartsheet: exclude holidays (I have a hidden holiday column) and leave work days total blank if date completed is empty.…
-
COUNTIF # INCORRECT ARGUMENT SET
I have a series of cells that aren't continuous, that I Ctrl/clicked into the formula. I want to count how many are Status N/A. I can't figure out why I am getting the Incorrect Argument Set error. =COUNTIF([BV App ID (1) Status]2, [BV App ID (2) Status]2, [BV App ID (3) Status]2, [BV App ID (4) Status]2, [BV App ID (5)…
-
RYG Formula Help
My formula keeps coming up as Unparsable and I cannot find the issue. Can anyone spot the issue? =IF(COUNTIF(CHILDREN(), "Green") / COUNT(CHILDREN()) > 0.6, "Green", IF(COUNTIF(CHILDREN(), "Yellow") / COUNT(CHILDREN()) > 0.4, "Yellow", IF(COUNTIF(CHILDREN(), "Red") / COUNT(CHILDREN()) > 0.2, "Red", 0))), IF(OR(ISBLANK([Due…
-
RYG automation based on percentage
I am hoping to get a formula to work for me- I have read a million boards and non of them work for me! What I am looking to do. If percent >=100, red circle If percent >= 50 and <100 yellow circle If percent <50, green circle this is the formula I am currently using; =IF([Percent of budget spent]2 >= 100, "Red",…
-
INDEX and MATCH #invalid value error
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
System Field: Date/TimeStamp behaviour
Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a…
