Please see the attached picture for actual help.

Tahirhanif891

Tahirhanif891 ✭✭

08/19/22 in Formulas and Functions

0 ·

Answers

Paul H Community Champion

08/19/22

Add Month# text column enter 1 though 12, you can hide this column if you want.
=SUMIFS([Sale Net Revenue]:[Sale Net Revenue], [Month#]:[Month#], <[Month#]@row, [Month#]:[Month#], >=([Month#]@row - 3))

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Counting occurrences of values in a multi-select dropdown list
I have looked through all of the answers for this topic, and still cannot find a solution that works for me. I have a sheet with a multi-select dropdown used to code responses. In another sheet, I want to count the number of times a certain value appears in any dropdown in the sheet column. Here is my formula:…
How would I write a formula to locate duplicates in 1 column and the difference in another column.
I have 1 sheet that has duplicated Classroom IDs but different scores on each line. I need to flag any instances during the same term of a difference over 1.00 higher or lower with the same Classroom ID. I need to find the repeat instances within column "Classroom ID" that occur during the same Column "Term Name" and then…
#NO MATCH result but not for identical formulas
I have two formulas that are fairly identical but one is producing a #NO MATCH error. =COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row)) This works just fine and returns the proper counts. The Shop column is a number/text field - and the Review Start Date is a…