Adding Letters to The End of My Results
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
Best Answers

@Kaleb appending
+ "d"
to your current formula will do that.= SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

@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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

@Kaleb appending
+ "d"
to your current formula will do that.= SUMIFS([Schedule Impact]:[Schedule Impact], Status:Status, "Open") + "d"

@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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

That Worked! I had the d on the Inside of the Parenthesis. Thanks Jeff & Toufong
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!