Adding Letters to The End of My Results

Kaleb

Smartsheet Community:

I would Like to add the Letter d to the End of my Results. Is that Possible?

Formula:

=SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open")

Results 9

Desired Results: 9d

Thanks

Toufong Vang

@Kaleb appending + "d" to your current formula will do that.

= SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

Jeff Reisman

@Kaleb Try this:

=SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

Keep in mind, adding text to a number value means the number value is now stored as text; you won't be able to use the numeric portion for calculations without stripping out the numeric portion and using the VALUE function on it. For example, if "9d" is in the Results column, and maybe you want to multiply the 9 value by the value in the Quantity column, your choices would be to use your original formula to get the 9 and multiply that by the Quantity, or to use something like this: =VALUE(SUBSTITUTE(Results@row, "d", "")) * Quantity@row.

Toufong Vang

@Kaleb appending + "d" to your current formula will do that.

= SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

Jeff Reisman

@Kaleb Try this:

=SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

Keep in mind, adding text to a number value means the number value is now stored as text; you won't be able to use the numeric portion for calculations without stripping out the numeric portion and using the VALUE function on it. For example, if "9d" is in the Results column, and maybe you want to multiply the 9 value by the value in the Quantity column, your choices would be to use your original formula to get the 9 and multiply that by the Quantity, or to use something like this: =VALUE(SUBSTITUTE(Results@row, "d", "")) * Quantity@row.

Kaleb

https://community.smartsheet.com/discussion/comment/356212#Comment_356212

That Worked! I had the d on the Inside of the Parenthesis. Thanks Jeff & Toufong