-
Copying rows w/ checkmarked cell to different sheet
Hello, I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns. Sheet 1: list of skus with descriptions and details. One column has a checkmark for the critical skus Sheet 2: auto copy (i.e. link) only specific columns for…
-
Automated Reminders showing all dates
I recently noticed that all dates including columns that are hidden are showing with my automated reminders. I have a number of calculated dates that I don't want to display. However, all of them now show on the reminders. This is a fairly recent development. I have emailed "Help" but, they have not responded in over a…
-
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?