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: Index Match Returning the Wrong Value

  bcwilson.ca

  02/04/21
  I think you have it Messed up.. you pasted.. INDEX({Sell Rate}, MATCH(Position@row, {Position}, 0) But your formula has INDEX({Sell Rate}, MATCH(Position@row, {Position}), 0). The bracket "}), 0…
  2 ·

• Re: Email address (mailto: link) in Dashboards

  bcwilson.ca

  05/14/21
  I worked with a competitive software and it was a simple HTML Field that could have calculations in. I think Smartsheet could easily implement this.. by creating an HTML column and rendering everythi…
  4 ·

• Re: Conditional Formattng for Dates in the Future

  bcwilson.ca

  05/18/21
  I think it is hard to do that logic in conditional format with dates. I would add a "cheater column.." say "sysFollowup" and do the math to add 30 days to the completion date. Thi…
  1 ·

• Re: Budget Management

  bcwilson.ca

  05/15/21
  @John DeLeon IV .. I tried with dynamic view but I ended up just using 1 web form by project. the vendor uploads the invoice.. puts some key details like invoice number and date and pricing.. then wh…
  2 ·

• Re: Automated RYG Balls

  bcwilson.ca

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

Next