Mike Wilday’s Profile

Community member since February 2017

University College at Azusa Pacific University
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc.



I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed,



   I have a task list with a flag column and collaborators in 5 columns, so a collaborator could be the primary responsible or up to a 5th level involved in a task. I haven't been able to use Countifs function in a formula which will retrieve from the list how many tasks a given worker is


My boss would like to put up a TV with live data (or somewhat live) from Smartsheet. We need it to be like a slideshow, showing graphs that we created on our dashboards. 


How can we do this using PowerPoint or any other software that works with


Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462

I need to show up CIT3462

thank you for the