Jgorsich
Jgorsich
Reactions
-
Re: IF Row @ Column A=Column B, then return Column C
Try =INDEX({SheetBServices}, MATCH([SheetA Order ID]@row, {SheetB Order ID}, 0)) Basically, the index function you already tried looks correct EXCEPT you want to index through your services column no…2 · -
Re: How to return count based on 3 conditions that must be true (two in the same column)?
You are specifying that it should only count things that are course 1001 AND completed AND incomplete - no row is both complete and incomplete, therefore 0. Nest your completed and incomplete criteri…1 · -
Community improvement - get alerts on conversations you participate in
This idea is actually for the community rather than the Smartsheet program; right now when you answer a question and the original poster replies to you, you only get an alert if they @ your name. Con…2 · -
Re: How can I make COUNTIF into a column formula?
I think this was inadvertently asked twice. Here is the other thread:1 · -
Re: How can I make COUNTIF into a column formula?
I feel your pain - I'm a big fan of using the same technique in Excel and finding a work around was a big priority for me. Luckily, I've got one for you! First, you'll need to add some kind of counte…1 ·
