Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time…
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,…
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 dif…
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 sta…
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 d…
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?
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 t…
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…
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 purp…
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). Fo…
