Archived 2016 Posts
Archived 2016 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
multiple fomulas in one cell
Hello i'm new to the smartsheet community and wondered if anyone can help.....
In one cell i need to use 2 '=RIGHT' functions and sum the answers together. is this possible?
an example of the text in a cell is "tuna sandwich - £1.50". the '=RIGHT function needs to return 1.50 and the same from another column then add them together to come to 3.00.
Hope this makes some sense to someone who can help 
thanks.
Comments
-
GC - I think you can use the text functions to identify the "RIGHT" text. However, since they will be text data, they cannot be added. I am not familiar enough with the functions to know how to convert the text to numerical data. Maybe someone else can chime in.
-
GC -
This is the function I found to work. It adds together the numbers in the rightmost 3 character positions in each cell:
=VALUE(RIGHT([Column2]8, 3)) + VALUE(RIGHT([Column3]8, 3))
-
GC,
Tim's answer is spot on.
If you have prices higher than 9.99GBP, say so.
The formula you probably want to work with then is FIND to parse your text without worrying about length.
Craig
