Formulas
Discussion List
- 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([…
- 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 c…
- 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) Ran…
- 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…
- 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 toda…
- 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)…
- 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. =C…
- 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") /…
- 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…
- 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 …
