-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
New data from Web Forms lands outside analysis range
We have a number of Smartsheets that gather data using web forms. Once the data has been gathered we analyse the responses received via the smartforms using formulea at the botton of the sheet (COUNTIF) This works really well and once we have this data in we can use the charts available in Smartsheet labs to present the…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?
-
SUM between Sheet 1 & 2 for Time range
Hi everyone, I'm stuck and need a little help. I'm trying to group Time ranges either both columns "A & B" if doable, or just column "A" into multiple 3-Hours bucket for the day with =FLOOR or similar and pick the highest number of Customers from same bucket/ time window of 3-hours with =LARGE from Sheet 1 & Sheet 2 then…
-
Card View - Selecting View By Lanes
I want to select a certain column from my sheet to be the "view by" lanes. I only have a choice of a handful of columns, none of which are very useful to me. The column I want is available to add to each card via "fields" but not in the "View by" selection. The columns I want either contains an equation/calculation and or…
-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
-
Automate End Month Date
Hi , I have started a Sheet to manage tasks for of the payroll Firm's I run I need to get into 1 cell automatically last date of the month so if its February its the 28th if its Jan should be automatically the 31st Which formula can I set up that it should automatically be set for end date of the month? so i can get set…
-
Range Starting point and then the rest of the row.
Hello, I am trying to reference an ever growing range in a COUNTIFS formula... but it starts at about Cell 150... I would like to have the range 150:infinity... any Ideas?
-
% Complete versus % Planned
Hi! I am trying to have two columns in my sheet: The original "% Complete" one and a "% Planned" one. It will help me check if my projects health is ok, by meaning if its percentage is above, equal or under the percentage of the project that was estimated for that date. I tried inserting a regular text/number column with %…
