Removing Partial Text From Prefilled Column

Jimrny ✭✭
edited 05/27/22 in Formulas and Functions


I'm currently using the following formula to extract just the time

=SUBSTITUTE([Completed Timestamp]@row, DATEONLY([Completed Timestamp]@row), ""

When used with automation/move by a check box being true, it populates correctly. However when using automation/move when rows are added and matching a "Category" column value, it populates with ", 11:00AM" a comma in front. This isn't a big issue but my other question is the following:

Is it possible to have the column that it moves to, remove the comma and space and leave the remaining End Time text?

Would the best formula to use is LEFT? or REPLACE?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!