About Paul_Janson

Paul_Janson · 12-28-2020

Hey guys, I’m looking to hire someone willing to take on a fun, low pressure side project. Joseph at GreenFlux has been an amazing mentor, but I’m realizing just how limited both my time and my abilities are, and I’ve decided I need to bring someone ...

Paul_Janson · 11-30-2020

I have a slice called ThisWeek that pulls from the data table all data that were entered during the current week. Since our week is Monday - Sunday, I had to do a little cajoling to get the appropriate data to show when a user is viewing the dashboar...

Paul_Janson · 11-22-2020

I have several child tables that need to have related data deleted when a parent row is deleted. All tables are deleting data properly with the “Is a part of” REF link except for one. The only thing I can think of is that something about the way this...

Adding new user · 11-22-2020

I’ve got a “new user” email Action that is triggered when a Teacher adds a new Student in the app. The email that the Student receives has a link to download the app. I’ve had an issue onboarding new Students through this email- they are getting an “...

Paul_Janson · 11-14-2020

I’m trying to create a virtual column that gives an average score for each user based on a sub-group categorization in another column. In the screenshot below, the first four columns are from my actual spreadsheet, the last two columns, Progress and ...

Paul_Janson · 12-29-2020

I learned this from @tsuji_koichi. It’s a quickchart graph. His original post is here. Progress Bar Chart ; new static image chart type in place! Tips & Tricks  Some people may say this is not bit deal, but for me, it is big! I introduced to the com...

Paul_Janson · 11-30-2020

Pure gold! Would never have thought to use USERSETTINGS this way. Thank you!

Paul_Janson · 11-30-2020

That’s very slick. I just tested it in ThisWeek slice and it works like a charm. Thank you!! This eloquently restates my cumbersome formula and eliminates the need for a test date, but it still doesn’t help me with the main issue, which is how to sel...

Paul_Janson · 11-30-2020

Not sure exactly what I did to fix it other than delete the table and recreate it. Could you be more specific about what you’d like me to add?

Paul_Janson · 11-25-2020

Deleting and recreating CategoryDash solved the problem. It was a pain, but well worth the effort. Thanks for the help!

My Stats

Paul_Janson's Bio

Badges Paul_Janson Earned

Recent Activity

Looking for an interesting, low-pressure gig?

Conditional row filter for slice?

Auto deleting child with "Is a part of" not working

Adding new user

Average by sub-type

Re: Looking for an interesting, low-pressure gig?

Re: Conditional row filter for slice?

Re: Conditional row filter for slice?

Re: Auto deleting child with "Is a part of" not working

Re: Auto deleting child with "Is a part of" not working