Excel Formula Training. Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. I can then add the timestamp formatted data from appsheet without any issues. I then manually change the column to be a number/text format type. Then change the column type to be date and tick restricted to dates only, smartsheet converts them all to dates and cuts off the time.