-
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 %…
-
Enhancement Request: Allow NO non-working days in WORKDAY function
I would like a small improvement to the WORKDAY function. For the third argument, we can pass in a range of dates. I want to pass in 0 or false or some other flag to IGNORE working days. =WORKDAY( {date cell} , 15 , 0 ) would return the date 15 days from now, regardless of project or global settings for non-working days. I…
-
Formula to display when a task is late based on start date and status/% complete
I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete. I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns. Thanks in advance community!
