Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How to put a date and time together in a column?

Hello, i am fairly new to smartsheet and Formulas, i was using a Created date column in Vlookup but looks like that column is in TEXT and is not being read as a Date and time.(maybe i am wrong).

i have managed to use a couple of formulas to bring out the date and time in 2 separate columns, i want to put them together now so it reads as the actual date and time.

for example, the date column has 18/02/24, and Time Column has 10:57 AM. i want the result to be 18/02/24 10:57 AM and it also should read as a date and time value so i can use it to subtract it from other date and time values to calculate the difference and also use in a V lookup formula


i hope this makes sense.🙏

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions