-
sumif with children and checkboxes
I'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 variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…
-
Help with If ISBLANK or statement
I'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 blank
I 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 formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month.
-
Link a summary sheet to multiple workplans
I'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 different stakeholders. Each project plan has an overall RYGB status, based on the 'worst'…
-
Conditional formatting
Hello, 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 Metrics
Good 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 include start/end dates, duration, dependencies, and % complete. We do not resource…
-
Time Formula - Drop Down Selection
Hello, 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 12:00 AM and ends at 11:55 PM, all increments of 5 minutes. For example, 12:00 AM,…
-
Percentage of certain cells in a column
Probably 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 together a formula that will calculate percentage of each city in the whole list. Any…
-
Quick poll: Case sensitivity of LOOKUP and MATCH
Hi 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 preference? Thanks, Daniel
-
Newbie: trying to return cell contents if date is less than and greater than...
I'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 Balance. I've tried, but keep getting errors. Thanks for your help.