Jgorsich
Jgorsich
Reactions
-
Rand() function
A rand() function to generate a random number is REALLY needed, format doesn't matter - just SOMETHING that allows us to generate a random number inside of the program.1 · -
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 ·
