-
Open-ended column on another sheet
I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet). Details: I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy…
-
#UNPARSEABLE Formula
I am trying to get this formula to work correctly in final calculations of a project we are working on. =IF([Column3]2="","",IF([Column17]2="",CONCATENATE("it's been ",TODAY()-[Column5]2," days"),IF([Column17]2-[Column16]2<0,CONCATENATE(-([Column17]2-[Column16]2)," days to spare"),CONCATENATE([Column17]2-[Column5]2," days…
-
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",…
