Delimit Date/time in a match/index function

Answers

Paul Newcome Community Champion

06/28/23 edited 06/28/23 Answer ✓

Total facepalm moment. Sorry. We need to also remove the space from before USD.

=VALUE(SUBSTITUTE(SUBSTITUTE([Column name]@row, "$", ""), " USD", ""))

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
1 · Share on Facebook Share on Twitter
murphyspccms ✭✭✭✭

06/28/23

Amazing. Thank you.

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

06/28/23

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Concatenate formula to combine Date and Time into unique code
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
Track unaswered questions
Hi guys I have a list of questions and the only answer expected is Yes or No from the dropdown. I want to track All unaswered questions, if it is blank i want the editor to see 70% Incomplete or 3 questions not answered something like that. All questions in the sheet don't change, see the sheet - Handover document…
How to fix adding 1 or -1 to date difference calculations
Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDAYS([Delivery Date Expected]@row, [Delivered Date]@row)) This is returning an almost correct result, except it always adds a…