How do I have sumifs equation that tracks if=both contribute new to new and renew to renew

JLADSK2992

JLADSK2992 ✭

09/11/24 in Formulas and Functions

We need to find out how to implement whether the equation is Both and how to associate new + renew.

0 ·

Answers

Adam Murphy ✭✭✭✭✭✭

09/11/24

Maybe a screenshot would help us understand what you are trying to do?

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

Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
Formula
I am trying to identify how many surveys taken at the start of the program are from the Jacksonville market using this formula =COUNTIFS({Time of Survey}, {Time of Survey}, "Week 1 of program", {Data}, "FLJAC Jacksonville") but it retuns as Incorrect # of arguments
Conditional formatting to help input mask/ensure social security has 9 digits
I've labored over trying to figure how to get around how SS gets input and for it to highlit if it doesn't contain 9 digits and hyphens. …as I'm typing this, I guess I could do it the same way I did my zip code and just leave out hyphens and have them inected into another column…. I'll work on that until I see someone has…