Formulas and Functions
Archives for January 2018
Discussion List
-
sumif with children and checkboxesIn Formulas and FunctionsI'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variat…
-
Help with If ISBLANK or statementIn Formulas and FunctionsI'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?
-
Formula to auto fill date based on last non blankIn Formulas and FunctionsI figured out the formula to give me exactly what I need in Excel: =IF(LOOKUP(2,1/(A1:D1<>""),A1:D1),EOMONTH(LOOKUP(2,1/(A1:D1<>""),A1:D1),3)) This formula does not translate to smartsheet. I need a for…
-
Link a summary sheet to multiple workplansIn Formulas and FunctionsI'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate project plan as they are shared with diff…
-
Conditional formattingIn Formulas and FunctionsHello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
Reporting Earned Value vs Planned Value for SPI MetricsIn Formulas and FunctionsGood afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that…
-
Time Formula - Drop Down SelectionIn Formulas and FunctionsHello, I've searched and it appears the time formula is an ongoing battle for enhancement requests. Looking for some help, I have two columns; 'Start Time:' and 'End Time'. There is a drop-down box on the web form and sheet that starts at…
-
Percentage of certain cells in a columnIn Formulas and FunctionsProbably it's easier than it looks to me, but I'm very new to Smartsheet and any help is highly appreciated. I have a column that contains name of several cities corresponding to complete projects in another column. I'm struggling to put…
-
Quick poll: Case sensitivity of LOOKUP and MATCHIn Formulas and FunctionsHi all, Our current LOOKUP and MATCH functions are case sensitive, e.g., "my task" will not match against "My task". Would folks expect these functions to be case sensitive, case insensitive, or do you have no prefere…
-
Newbie: trying to return cell contents if date is less than and greater than...In Formulas and FunctionsI'm new at this. Let's say these are my three columns: Open Balance | AR Due Date | WK 1 So in the WK1 cell I want this formula: If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open B…