Services

\" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…","categoryID":322,"dateInserted":"2019-09-27T04:41:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-28T05:09:33+00:00","insertUserID":84161,"insertUser":{"userID":84161,"name":"SBash","url":"https:\/\/community.smartsheet.com\/profile\/SBash","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T11:10:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":82,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/58731\/formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58731\/formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":57936,"type":"discussion","name":"Data Loader Expression Input value","excerpt":"I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…","categoryID":320,"dateInserted":"2019-09-17T20:49:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-25T17:47:32+00:00","insertUserID":58041,"insertUser":{"userID":58041,"name":"debojyoti.dutta58041","url":"https:\/\/community.smartsheet.com\/profile\/debojyoti.dutta58041","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!m4jXny2tYqY!4cNWOBXHTXo!DAKDdG5Vso0","dateLastActive":"2020-09-15T23:22:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":58041,"lastUser":{"userID":58041,"name":"debojyoti.dutta58041","url":"https:\/\/community.smartsheet.com\/profile\/debojyoti.dutta58041","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!m4jXny2tYqY!4cNWOBXHTXo!DAKDdG5Vso0","dateLastActive":"2020-09-15T23:22:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":469,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/57936\/data-loader-expression-input-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57936\/data-loader-expression-input-value","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
Capturing the Date and Time a Cell in Smartsheet was created or modified?
How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.
How to Create A Template Set
我已经创建了几个项目管理files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
Dashboard opening position
I currently have a large dashboard which is opening about 3/4 of the way down. Is it possible to set so the first view is at the top?
Add attachment to multiple sheets and respond?
I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert, they can attach a file. What I would like is for the attachment to be added to the…
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
Adding row number to email sending attachment
We frequently send attachments to the next task owner (example, from document drafter to document editor), and we want the person receiving the attachment to know in which row the attachment is posted. Is there a way to do this? Right now the email just has a link to the doc.
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…

Services

Discussion List