Removing Partial Text From Prefilled Column
Hello!
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?
Answers
-
I tried using RIGHT, but it gives me a blank.
=RIGHT([End Time]@row, (FIND(",", [End Time]@row) - 1))
-
=RIGHT([End Time]@row, (FIND(",", [End Time]@row) + 8))
Seems to work out!
-
Hi @Jimmy
I'm glad you found a solution! Thanks for posting it for our other members.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!