combining them in the same column

marcusben
marcusben ✭
inFormulas and Functions
image.png


Hi,

Can we show the date and time by combining them in the same column?

thanks

Tags:
· Share on Facebook Share on Twitter

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @marcusben

    Excellent, and I am too!

    Happy to help!

    Try something like one of these options.

    =JOIN([Starting Date]@row:[Start Time]@row, " - ")


    =[Starting Date]@row + " - " + [Start Time]@row

    Did that work?

    ✅Remember!我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter

Answers

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公式手册模板!
@Lauren E<\/a> oh yeah that makes sense! You can also do it without value and without quotes:<\/p>

=IF(Status2 = \"Not Started\", 0, IF(Status2 = \"In Progress\", 0.5, IF(Status2 = \"Completed\", 1)))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-17 18:28:38","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-17T18:46:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":99757,"type":"question","name":"workflow, not seeing other sheets","excerpt":"I've been added as an admin to an original sheet, I'm trying to create a workflow to copy lines, that meet a certain criteria, to a sheet I've created, but when I'm in the workflow I see no other sheets to be able to copy the lines to. I've created similar workflows before and have not had this issue. The only difference…","categoryID":322,"dateInserted":"2023-01-17T13:26:02+00:00","dateUpdated":null,"dateLastComment":"2023-01-17T13:38:57+00:00","insertUserID":156914,"insertUser":{"userID":156914,"name":"CMathis","url":"https:\/\/community.smartsheet.com\/profile\/CMathis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T13:33:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156914,"lastUser":{"userID":156914,"name":"CMathis","url":"https:\/\/community.smartsheet.com\/profile\/CMathis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T13:33:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":26,"score":null,"hot":3347927099,"url":"https:\/\/community.smartsheet.com\/discussion\/99757\/workflow-not-seeing-other-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99757\/workflow-not-seeing-other-sheets","format":"Rich","tagIDs":[448],"lastPost":{"discussionID":99757,"commentID":357292,"name":"Re: workflow, not seeing other sheets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357292#Comment_357292","dateInserted":"2023-01-17T13:38:57+00:00","insertUserID":156914,"insertUser":{"userID":156914,"name":"CMathis","url":"https:\/\/community.smartsheet.com\/profile\/CMathis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T13:33:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-17T13:34:51+00:00","dateAnswered":"2023-01-17T13:30:17+00:00","acceptedAnswers":[{"commentID":357288,"body":"

Hi @CMathis<\/a> <\/p>

I hope you're well and safe!<\/p>

Ensure that the below is true.<\/p>

The sheet Owner and Admins on both the source and destination sheets can create an automated move or copy rows action. A license is required.<\/em><\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Have a fantastic week & Happy New Year!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-17 13:34:51","updateUser":{"userID":156914,"name":"CMathis","url":"https:\/\/community.smartsheet.com\/profile\/CMathis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T13:33:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":99743,"type":"question","name":"Formula Tweak","excerpt":"Hi - How to I adjust (add to) this formula so it sums Green and Gray for Clark Usher? =COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, \"Clark Usher\", [Primary Status]1:[Primary Status]10, \"Green\")","categoryID":322,"dateInserted":"2023-01-16T22:11:45+00:00","dateUpdated":null,"dateLastComment":"2023-01-17T15:16:46+00:00","insertUserID":155568,"insertUser":{"userID":155568,"name":"Clark Usher","url":"https:\/\/community.smartsheet.com\/profile\/Clark%20Usher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T15:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155568,"lastUser":{"userID":155568,"name":"Clark Usher","url":"https:\/\/community.smartsheet.com\/profile\/Clark%20Usher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T15:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3347876911,"url":"https:\/\/community.smartsheet.com\/discussion\/99743\/formula-tweak","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99743\/formula-tweak","format":"Rich","lastPost":{"discussionID":99743,"commentID":357313,"name":"Re: Formula Tweak","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357313#Comment_357313","dateInserted":"2023-01-17T15:16:46+00:00","insertUserID":155568,"insertUser":{"userID":155568,"name":"Clark Usher","url":"https:\/\/community.smartsheet.com\/profile\/Clark%20Usher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-17T15:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/C4R7HUEQ3TQP\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-17T16:21:15+00:00","dateAnswered":"2023-01-17T11:56:34+00:00","acceptedAnswers":[{"commentID":357281,"body":"

Hi @Clark Usher<\/a>,<\/p>

You're halfway there!<\/p>

If your data range is not going to get any larger then the following formula works:<\/p>

=COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, \"Clark Usher\", [Primary Status]1:[Primary Status]10, \"Green\")+COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, \"Clark Usher\", [Primary Status]1:[Primary Status]10, \"Gray\").<\/p>

If you wanted it to be able to take in any future data being added, then remove the numbers in the range so the formula looks at only columns:<\/p>

=COUNTIFS([Primary Reviewer]:[Primary Reviewer], \"Clark Usher\", [Primary Status]:[Primary Status], \"Green\")+COUNTIFS([Primary Reviewer]:[Primary Reviewer], \"Clark Usher\", [Primary Status]:[Primary Status], \"Gray\").<\/p>

This is assuming you are only looking at Primary Reviewer - you would need to expand the formula further if also counting secondary reviewer.<\/p>

Hope this helps, if you have any questions please ask! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-17 16:21:15","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-17T18:46:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">