JamesR ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	23

About Me

About Me

Area of Expertise	Web Forms
About Me	Long career in Microsoft Office training, development and consultancy in all Applications to Advanced level including VBA.
How I Use Smartsheet	I am a Smartsheet consultant and assist companies in developing Smartsheets to meet their Business needs, resolve issues and train users.

Analytics

501

Posts

0

Visits

3.8k

Points

Mar 6, 2015

Join Date

Jul 19, 2019

Last Active

Reactions

• Insightful 3

  3
• Vote Up 11

  11
• Awesome 1

  1

• Activity
• Discussions16
• Comments485

• Re: exact match formula in Smartsheet

  JamesR

  05/28/15
  Exact is not a formula that is available in Smartsheet. Work arround: Create a report that only has the two columns you want to compare. Export to Excel and use your Exact in there. Not ideal but wou…
  1 ·

• Re: Keep indent on the reports (and on sights)

  JamesR

  01/31/17
  Currently Reports do not support the display of Hierarchies. One of the reasons is that Reports can be used accross multiple sheets and therefore it may end up puttingsomething under the wrong Hierar…
  1 ·

• Re: Past Due Reporting

  JamesR

  05/09/15
  Create a Flag field that is calculated to turn Red if the Completed d ate is greater than the Due date. Reprort on the Flag being Red
  2 ·