How to count the number of photo shoots, not completed, by brand? COMPLEX???

Shawn_K2 · 2024-03-26 22:29:41

Trying to get the summary of the amount of photo shoots from one column, not checked completed from second column, and sorted by the brand by third column. So three columns. (Brand column with specific brand) + (OW Shoot Date column) + (Photo Shoot Complete column) = Total shoots by brand.

Answers

hook ✭

08/13/24

Thank you very much. I'm going to try it.

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

Trending in Formulas and Functions

NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
Help with Average Formula
Hi there - I'd like to ask for a hand to calculate an average formula. This is a cross sheet formula where I want to aggregate an average time duration by Assigned To, by quarter. (I also have instances where my time duration is zero - I think that was causing me a divide by zero error). Metrics sheet/destination: Source…
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…

How to count the number of photo shoots, not completed, by brand? COMPLEX???

Answers

Help Article Resources

Categories