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.com
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.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

I have a formula that I cannot get right
Hi, I am taking Justin Orazio's Smartsheet made Simple course. I am in the cross-sheet referencing class. I have watched him create the formula over and over but mine just doesn't work. It doesn't give me an error, but it also doesn't count up the number of sales by the month per project manager. Can someone help me? Below…
#Invaldi Operation when a date dell is blank
Trying to analyze multiple date columns against a current date to ensure the training has occurred within the last year and if not then flag as needing to be trained. But when I incorporate the various date cells for reference I get the #invalid operation error for the blanks. Formula: =IF(OR([DTMC & Trainer Training…
LookUp Results then Automate Resonse
Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo…