or Explore Discussions

# Formulas

## Discussion List

• Update Request with "add/subtract" formula to an existing number in a row?
In Archived 2016 Posts
A bit new to SS, so this may have an obvious answer, but I'm trying to set up a sheet to track inventory of, say, a dozen products. The initial setup is obviously simple, but then I want to choose the product rows that contain inventory qu…
258 1
Closed 258 views 1 comment Most recent by Richard Rymill SBP Archived 2016 Posts
• Add Years to a Date
In Archived 2016 Posts
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years.   What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15.    =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY…
522 2
Closed 522 views 2 comments Most recent by Amanda Chu Archived 2016 Posts
• % Complete column can only be updated manually?
In Archived 2016 Posts
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.
188 7
Closed 188 views 7 comments Most recent by J. Craig Williams Archived 2016 Posts
• =AVGIFS Function Workaround
In Archived 2016 Posts
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 C…
55 2
Closed 55 views 2 comments Most recent by Dave D Archived 2016 Posts
• Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
In Archived 2016 Posts
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 appa…
385 1
Closed 385 views 1 comment Most recent by JohnHinkle Archived 2016 Posts
• Help with Duration by assigned to formula
In Archived 2016 Posts
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?
93 6
Closed 93 views 6 comments Most recent by Christine Salmon Archived 2016 Posts
In Archived 2016 Posts
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 t…
74 3
Closed 74 views 3 comments Most recent by Mel G Archived 2016 Posts
In Archived 2016 Posts
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…
181 3
Closed 181 views 3 comments Most recent by J. Craig Williams Archived 2016 Posts
• Is there a way to select from a project schedule the next upcoming milestone?
In Archived 2016 Posts
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…
41 3
Closed 41 views 3 comments Most recent by J. Craig Williams Archived 2016 Posts
• Using reports in Sights Metric Widget
In Archived 2016 Posts
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,…
45 1
Closed 45 views 1 comment Most recent by Daniel Stein Archived 2016 Posts