Counting the Number of Attempts for one Professioin

Vinton Douglas

Vinton Douglas ✭✭✭

06/27/22 in Formulas and Functions

Screen Shot 2022-06-27 at 12.41.29 AM.png

0 ·

Answers

Paul Newcome Community Champion

06/27/22

Try somethign like this:

=SUMIFS(Attempts:Attempts, Profession:Profession, @cell = "Teacher")

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
1 · Share on Facebook Share on Twitter
Vinton Douglas ✭✭✭

07/09/22

Thank you. Works fabulous.

0 · Share on Facebook Share on Twitter
Vinton Douglas ✭✭✭

07/09/22

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

07/11/22

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

Attempting to add to a large formula but getting #unparseable
Attempting to add a fifth sheet reference mimicking the previous ones in the formula however getting UNPARSEABLE. I attached a photo of the formula and the updated one below (if i paste it breaks my post) and when in the sheet i notice that the () around cell are orange on the original and green on the new ones so maybe i…
Sheet summary formula to return first value above 0
Seeking a sheet summary formula to return the first value above 0 for "Countdown" column. This value will be displayed as "Countdown to next launch" in a dashboard.
Another If Formula
=IF(NOT(ISBLANK([Payment Type]@row)),CONCATENATE([Payment Type]@row,"-",TEXT([Invoice Date]@row,"MM/DD/YY"),"-PD-",TEXT([Posted Date]@row,"MM/DD/YY")),"") I cant figure out whats wrong with this formula. The column names all work and are named appropriately