bcwilson.ca ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	15

About Me

About Me

Area of Expertise	At one time in my career.. I was ultimately responsible if a washroom had no toilet paper at a car dealership in Montreal while concurrently Designing, Permitting and constructing a $60 Million dollar car dealership in British Columbia.. So pretty much everything between those two extremes
About Me	A Profession Engineering with background in Process and Industrial IT, and Construction
How I Use Smartsheet	To juggle chainsaws
Linkedin	https://www.linkedin.com/in/brentcwilson/

Analytics

65

Posts

83

Visits

2.2k

Points

Nov 1, 2018

Join Date

Jun 15, 2021

Last Active

Reactions

• Insightful 16

  16
• Vote Up 23

  23
• Awesome 2

  2

• Activity
• Discussions3
• Comments62

• Re: Harvey Balls for Due Date

  bcwilson.ca

  05/14/21
  =IF(Status@row = "COMPLETE", "Gray", IF([DUE DATE]@row < TODAY(), "Red", IF([DUE DATE]@row <= TODAY(7), "Yellow", "Green"))) Now I will explain…
  1 ·

• Re: complex if/and/or question

  bcwilson.ca

  02/03/21
  My trick is to create a series of helper columns that will help you write the if case.. When it is done then you can use a text editor to copy and paste the formulas into each other to create a massi…
  1 ·

• Re: Budget Management

  bcwilson.ca

  12/15/20
  Yes, there are a few dashboards.. but more for navigation and accessing the reports. Accounting gets a workflow email once the status of the invoice is set to approved.. It emails them as to what GL …
  2 ·

• Budget Management

  bcwilson.ca

  12/11/20
  All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows …
  7 ·

• Re: Introducing a new report builder plus grouping and summary for reports

  bcwilson.ca

  12/11/20
  @Brendan Reed .. Now the next step is to create savable filters on the reports like sheets so that Users can use one report instead of multiples.. An example they can click and say overdue orders and…
  11 ·

Previous Next