Chris McKay’s Profile

Community member since September 2017

Company Management
Area of expertise
Project Management
About Me
Program and Project Management professional with 20+ years experience in a variety of industries, including Banking & Finance, Management Consulting, Telecommunications, Data Science and Retail.

I've only been using Samrtsheet for 9 months now, but I have 15 years experience as an Excel SME including custom solutions using VBA and external Data.


I've been using Smartsheet for about 12 months now and have been active on the Community site for most of that time. During this time I have seen requests for fundamental features like multiple resources, access to time, project baselines etc. go through the same lip service mouse wheel scenario.


I am growing increasingly frustrated with not being able to get in touch with help early in the morning (east coast).  What are the hours that sales and support work?  I can't find it posted on the website anywhere.  Having to wait until midday to get a hold of anyone is really a pain and causing



I am trying to implement the following formula from my excel spreadsheet into my smartsheet:

=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"

Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and