J. Craig Williams’s Profile

Community member since November 2015

See "About me" below
Project Management
Area of expertise
Web Forms
How I Use Smartsheet
Daily tasks, any around the house or longer than a few days projects, project management, resource management.
About Me
Smartsheet Certified User

Simulation engineer / engineering, project, and program manager
Passionate about continuous improvement and knowledge sharing

If you need help with Smartsheet, contact me via craig.williams@smarterbusinessprocesses.com or contact Richard Rymill at Smarter Business Processes

If you need help with something else, contact me via craig.williams@ronin-global.com

Also I post tips and tricks for Smartsheet here:



We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to


Hi. I have several smart sheets with 2 columns, being the first column common to all. What is required is to have an aggregated smartsheet with the common first column and append the second columns of the other smart sheets.


Smarthsheet 1

Subject    Juan

math           A

physics       B


I have cell one that has a function in it say IF(1=1,true,false) and it outputs true. I then want to do a vlookup for that true value, but I keep getting that no such value exists. I assume that's because the cell actually contains the formula rather than the value true. Is there a way to reference