-
Adding a Title to a COUNTIF formula
I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have for the parent row: ="May 2018" + " (" + COUNT(CHILDREN()) + ")" This formula displays in the cell as May 2018 (3) ~~~~~~ I…
-
Linking rows
Hi guys, I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel. I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen…
-
Project Roll Up
Good Morning, I am struggling with presenting a project roll up including gant in a clean view. I would say a program view is what I was wondering if anyone had some guidance on. Thank you. Lynn
-
Nested IF using additional AND logical functions
I am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages. My formula is right now as follows: =IF(ISBLANK([RESPONSE DATE]88); "Gray", IF([RESPONSE DATE]88 <= [ORIGINAL DUE DATE]88; "Green", IF(AND([RESPONSE DATE]88 >…
-
Variance Column Showing 1.. Needs to be 0! Help!
Hi all - I am working on a variance formula to first.. if error make a blank... and then to secondly... calculate the number of working days between to dates. I need the variance of our "planned end" and "actual end" columns. I have the formula just about right! But it is producing a 1 instead of zero when the dates match.…
-
countif to total summary two different values into one
I have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS. So I tried countifs(Range:range, CAR, Range:Range, BUS) however that doesnt seam to work.…
-
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Need a workaround so Parent Rows stay children rows when sorting
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…
-
IF(AND) Syntax Question
I am trying to correct the SYNTAX for the below scenario as I repeatedly get #INCORRECT ARGUEMENT SET as a result on line 3. In the column labeled "Today" I have the following formulas: LINE 1 =IF(MONTH(TODAY()) = [DOJ Anniversary (M)]1, "YES", "NO") ..... This returns the expected result. LINE 2 =IF(MONTH(TODAY()) = [DOJ…
