Mike Wilday’s Profile

Community member since February 2017

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

2

Hello,

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,

3

Hi,

   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

3

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

1

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