-
% Complete column can only be updated manually?
Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
-
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with: =IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"") However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion…
-
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
-
Help with Duration by assigned to formula
I need to sum the duration colums by assigned to if the status is complete. I am having so many errors when trying to do this. Can anyone help?
-
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells…
-
creating formula to add many non-adjacent cells
I need to sum/add many (~120) non adjacent cells. They are all in a single column. When I create a formula and start clicking in the cells to include, I keep being returned to the bottom of the sheet where the formula is calculated. Then I have to scroll back up to the top of the sheet to access the next cell I want to…
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Using reports in Sights Metric Widget
Hi, Is there way we can use Reports within a the Metric Widget in Sights? I have a set up where I am trying to display "Counselor of the Day" in this widget, but my only option is to use the sheet as a source. When I do this, the link to the source cell is static and It only points to the cell that was initially selected.…
-
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
-
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
