# nlarsen’s Profile

points
176

=SUMIF([Total Sales of Goods and Services]@row :[Total Sales of Goods and Services]@row, [Payments in Quarter]@row = "Q.3.18"))

The purpose of this formula is to sum all totals of Total Sales of Good and Services if the Payments were made in Quarter 3, 2018; I'd like to make this formula workable

Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm

I'd like to write a formula based on Start Date and End Date Columns:

If Start Date is less than or equal to today and End Date is greater than today or blank, I want "In Progress"

If Start Date is less than or equal to today and the End Date is less than or equal to today, "Complete"

If Start Date

Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were

I am trying to count if a dept name is matched  then count 2 different criteria's in the same column  (all in another sheet)

I can get it to count all of the approved but I can not get it to count both

This is what is working =COUNTIFS({Tracking Range 2}, "Dept", {Tracking Range 1}, "Approved")

How

I have an at risk column with flags. I am need a formula that will turn the flag red when its past a due date, and not marked complete.

I used this formula

=IF(AND([Date Needed By]1 < TODAY(), [Cabinet Complete]1 = 0), 1, 0)

this works for the current row, but when I drag down to copy to cells

I have two columns:

• [Infrastructure Project] is a checkbox
• [Product Priority] is stars (0 - 5)

If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars.

This would be simple if [Product Priority] were

=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green"))))

Very new at this, but I can't see the

Hi, having an issue with charts. I'm thinking there must be an easy solution that I'm missing. I am trying to create a chart in a new dashboard. When I select the data from a sheet or report, the following error comes up "Invalid Data. To create a chart you must use numeric data". The data in the

I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column.

I've come up with the formula below, but I get an Incorrect Argument error:

=COUNTIFS({Review Month}, =1, ISTEXT({Critical 1}))

Where am I wrong