Comments
-
Try putting this in each empty cell in the sheet you screenshotted above, and create the cross-sheet references: =COUNTIFS({Status}, $[Primary Column]@row, {Contact}, [Column 2]$1)
-
@BullandKhmer Sorry you're experiencing issues. My response above was from me directly, Smartsheet had nothing to do with my answer. Thanks for the tip. Hope it gets worked out for you.
-
@Connie Cochran Does the primary column of the sheet always have a value in it? Or is there another column that always has a value in it? If so, use this formula but replace the "Primary Column" with a column that always will have a value: =(COUNT([All screeners present at event]:[All screeners present at event]) /…
-
@Connie Cochran Glad it worked out!
-
@BullandKhmer That's weird. It's working for me when I test it out.
-
@Connie Cochran Strange. It's working for me in the example below. Can you share a screenshot of the sheet/columns?
-
@blmccue When I put the formula in a test sheet it works for me. Did the formula end up working for you?
-
@Jason Voorhies Glad it helped. Feel free to reach out if you have other solutions you're working through.
-
@Connie Cochran Try this: =(COUNTIF([All screeners present at event]:[All screeners present at event], "Red")) / COUNT([All screeners present at event]:[All screeners present at event])
-
@Jason Voorhies Here's an example: Check out the formulas in the Expense Month column and the Monthly Sum column and see if that helps you apply them to your use case. I've included the formulas below: Expense Month: =IF([Expense Date]@row = "", "", MONTH([Expense Date]@row)) Monthly Expense Totals: =SUMIF([Expense…
