Delimit Date/time in a match/index function

Answers

Paul Newcome ✭✭✭✭✭✭

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.com
1 · Share on Facebook Share on Twitter
murphyspccms ✭✭✭✭

06/28/23

Amazing. Thank you.

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

06/28/23

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

Checking off a box in one form when another is filled out?
Hello! I am very, very new to Smartsheet so please forgive me if this isn't the right place to ask or a dumb question. I am attempting to make a sheet that records when someone has filled out a form on another sheet. The original sheet is a form for a customer service survey, and the one I want to make records when and if…
Using IF with CONTAINS and AND for multiple columns
I am looking at two different columns - one is called Status and the other Priority. I would like to have a formula/function setup that will look for "Open" within the Status column and "High" within the Priority column. If it finds "Open" and "High" together in any row, I want a "True" value returned. This will be used in…
Move Row to New Sheet
I'm trying to figure out how to move a row that contains "New Trip Report" when a new row is added containing "Corrected trip report" and the Report ID's match. For example: see screen shot. Adding row 2 containing Report ID TR00001TX115 would trigger moving row 1 to a new sheet. If anyone knows how to do this, please let…