-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
Extract selected data from sheet (without using report)
Hi Smartsheet community! I have the following problem: I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to extract an shipment overview from this complete list of items that only includes the…
-
Gantt Chart Formatting Gaps
Hey, I have been making some project programmes for my boss to present and there are occasional (seemingly random) lines running down the gantt chart. Some are at the end of a week some are at the start of the week, they are all of different widths. When the chart is exported and printed it is very distracting and I don't…
-
Cross sheet reference multiple cells by dragging
Hello everyone, I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the rest of the cells but noticed that the formula does not change if it is dragged. Is…
-
Grouping Rows or Columns
Can you group rows or columns liek you can do in Excel so that you can click on a symbol or such and open up a section of information for easier viewing?
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Trying to create Cumulative Flow chart from task list
I am attempting to build a cumulative flow chart based on new, active, closed tasks. The struggle is coming from trying to build a sheet with formulas that will pull the information from the task list and hold onto the information moving forward. Once the formula finds the correct data it continues to update each cell with…
-
Conditional formatting of dates
I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?
-
Sort not working for Editors?
There is probably a easy explanation or fix for this but I can't figure it out. I have a sheet with about 10 editors that as things move on the sheet it needs to be resorted (sorted by a due date). For some reason I am the only one that can sort the sheet, the Sort option is greyed out on all of thier sheets - I've…
-
Adding rows to another sheet automatically
Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet B) . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). Sheet C is a static lookup table. Is this possible?