Using RIGHT/LEFT or FIND/REPLACE?

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

I thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me.

Would using FIND/REPLACE work, such as finding ", " within the column and replacing that with just "" so it would just leave me with the Time value?

This all stems from using the following formula to extract just the time on another sheet.

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

When used with MOVE/Automation with a check box value being true, it populates correctly. However when using MOVE/Automation when rows are added via form submission and has a matching value in a Category column, it populates with a comma in front on the End Time value.

Example: ", 2:41 PM"

I figured I could just create a helper column to remove the comma and space that populates as a prefix before the time value.

Any help on a proper formula for this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!