Chris McKay’s Profile

Community member since September 2017

points
1461
Department
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.

3

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.

2

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

15

Hi,

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