I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field.
I tried to apply the same forumula but not working on smartsheet.
Is there a way to calculate subtoal of the filtered rows? Please