Mike L.’s Profile

Community member since April 2018

About Me
New to smartsheet



I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description.


My formula in the Time and Attendance row works as expected. The data for overall status, scope, timeline, resources and


I am trying to use an Excel date-related calculation in Smartsheet and I'm having trouble translating it into Smartsheet. Any thoughts on the situation below? 

Column A (Deadline) is manual entry of Deadline date - no issue there.

Column B (Due in Next 60 Days) is supposed to return "TRUE" if the