79703951

Date: 2025-07-16 19:46:51
Score: 0.5
Natty:
Report link

Try this : This will include all rows, even if they are collapsed.

101 ignores the hidden row but 1 includes the hidden row

=IFERROR(IF(SUBTOTAL(1,[Shortcut])>2,

ROUNDUP(SUBTOTAL(1,[Shortcut]),0),

ROUND(SUBTOTAL(1,[Shortcut])-0.01,0)

),

"-")

Reasons:
  • Whitelisted phrase (-1): Try this
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: skroutela