Best Of
Re: Extract text from Cell String using delimiters “|” into separated columns
For the column pulling the first pc of information (Country) you would use the below:
=IFERROR(LEFT([TEXT_COLUMN]@row + " | ", FIND(" | ", [TEXT_COLUMN]@row + " | ") - 1),"")
For the other columns use the below, and increment the number bolded.
=MID([TEXT_COLUMN]@row + " | ", FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 1)) + 3, FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 2)) - FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 1)) - 3)
=MID([TEXT_COLUMN]@row + " | ", FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 2)) + 3, FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 3)) - FIND("~", SUBSTITUTE([TEXT_COLUMN]@row + " | ", " | ", "~", 2)) - 3)
Communityで人気のコメント
Smartsheet Community (英語版)で人気のコメントのうち、「いいね!」と思ったものをご紹介します。
第1回目は、Smartsheetの コミュニティチームのジュヌヴィエーヴ(Genevieve P.)さんが回答した、「同じプロジェクトシート内の異なる設定」についての回答です。
https://community.smartsheet.com/discussion/comment/418646#Comment_418646
はじめに
Smartsheetで同じプロジェクトシート内に、異なる勤務日と時間を持つタスクを作成する方法について質問がありました。
具体的には、週7日勤務(土日祝日なし)と、週5日勤務(祝日あり)のタスクを同じシートで管理したいというご要望でした。
質問の要約
異なる勤務日と時間を持つタスクを同じプロジェクトシートで作成することは可能ですか? 週7日勤務と週5日勤務のタスクをどのように管理すればよいですか?ダッシュボードは使用しません。
答えの要約
はい!プロジェクトシートで特定の勤務日と時間(例えば週5日勤務と休日)を有効にしている場合、週7日勤務にしたい特定の行では、期間の前にeを追加することで経過時間を使うこと
下のデモシートはジュヌヴィエーヴさんのデモシートを日本語化したものです。
https://app.smartsheet.com/b/publish?EQBCT=a343fb0967ab4c43aa190f2772ee979c
方法
プロジェクトシートで特定の勤務日と時間(例:週5日勤務と休日)を有効にします。
週7日勤務にしたい特定の行では、期間の前にeを追加することで経過時間を使用します。
詳細
期間と先行タスクを使う:
期間の列で継続期間を使用すると、非稼働日が考慮されません。 継続3日、継続5時間、継続3.5日のように表示されますが、e3d、e5h、e3.5d と入力してもかまいません。また、「継続」の代わりに「継続期間」や「継続時間」と入力することもできます。
ポイント
週7日勤務と週5日勤務のタスクを区別するために、e記号を使用する。
Re: February Question of the Month - Join the conversation and receive a badge
Hello SmartSheet Community,
When I was a kid, I wanted to be a UPS driver when I grew up. Long-term employment at UPS runs in my family, so that was all I knew as a kid. I idolized the brown uniform and the big trucks because I remember how much time both of my parents spent at work, even during the holidays. Although I did not become a UPS driver, I did eventually work for UPS for 5 years and experienced positions in many different departments.
Now, I work at the Lawrence Livermore National Laboratory as a Business Analyst in the Finance department. I work with different financial systems and help improve business processes and procedures while maintaining effective working relationships. Although I don't get to carry on the UPS legacy, I remain honored to use past experiences and apply my skills and knowledge to the prestigious organization.
Thank you!
DesireeJones
Re: Automations: include attachments
I am facing the same issue.
So, 'vote' for the ability to attach all documents on notifications, no matter when they were added.
Thanks.
Re: Automations: include attachments
I agree, the ability to include attachments to automated emails is vital. I'm also finding colleagues are getting lost in the sheet when they click the link in the email. Its really slowing down one of our internal processes too as we need to forward on the detail collected in a form to another department that won't use the smartsheet to download the attachments so we then need to have the automated email sent to the requestor for them to add the attachments to send.
Rich Text Format in Sheet Cells
We have been converting all our projects to Smartsheet and now have about 86 projects loaded. A big issue for us is, (I would like to know how many other people would want this) we have a column in our status reports that go to our VP's called "Status Comments". The VP's are used to seeing comments with bullet points, issues in red font, sub-headers in the comments in bold, etc. This is not possible in Smartsheet.
By the way, I am not advocating for every type field to be RTF. I would be fine if they added a new column field type called RTF Text. That way it could be added only where needed.
The issue is when the company requires fairly lengthy status comments not having RTF makes the text difficult to read quickly to find what you want. Plus, they had this in the previous method of reporting, so for them this looks like a step backwards.
I have put in enhancement requests but have heard nothing. If having RTF in comments is something you would like to see, then go out and put in an enhancement request for this.
Keep auto number as number, do not turn it into text when using Numerical Places.
When creating an auto-number column, if you choose anything different than Numerical Places being 0, it will detect the column as text.
Therefore, making calculations with the auto-number column behaves different depending on the properties used.
For example, the formula =[Row ID]@row + 1 shows different outcomes as the following:
If Numerical Places is 0, it will sum the value turning Row ID 1234 into 1235
If Numerical Places is 0000, it will add the 1 as text, turning Row ID 1234 into 12341
This mismatch on the behaviors also affects other features such as sorting or indexing and should not be considered expected when the same column name already has the word "number" on it.
Sheet Summary Report - Highlight Changes - Make the Button work
They told me to post this here rather than just forward it internally, which is really surprising actually, but can you please make the highlight changes button available on sheet summary report actually highlight changes? I don't know what it would even be there if it didn't already, but it doesn't and I confirmed in the support email below. . .
________________
Hello,
Thank you for contacting Smartsheet support! I have been looped in to further assist you with your issue.
As sheet summaries can’t be highlighted even when applying the change directly to the report it will not highlight the change.
So, thats why when you have a moment, please submit your feature request to the Product team by signing in to the online Community (the Community uses your Smartsheet account to sign in) and create an Idea post in the Smartsheet Product Feedback and Ideas topic.
Posting your enhancement in the Community will allow other Smartsheet users to see and vote on your idea!
--------------- Original Message ---------------
From: Dan
Subject: Re: 06701988
Thanks for checking on your end, Malcolm, I'm glad to hear it's not just me and that feature doesn't work in spite of the button being there on the Sheet Summary Report.
I do have to ask you the same question I posed to Jaryl per your response: we're acknowledging that the "Highlight Changes" button that is already on the Sheet Summary Report does nothing, and you'd like me to submit a feature request to your product improvement team asking that they make it work?
Notifications include Cell History
Please consider adding an option or field name (e.g. {{history-start date}}) within notifications to share what the cell contents were BEFORE a change occurred.
I have a notification that goes out to users when something like a start date changes in a Sheet. While I can send the new cell value in the notification, it would be nice to be able to include what the cell value was prior to the change. This information is already tracked within cell history, but would be helpful to include it in notification E-mails rather than the user having to go into the sheet and review cell history.
A sample notification E-mail might be:
The Start Date {{history-Start Date}} has been changed to {{Start Date}}
The Start Date 11/22/23 has been changed to 12/10/23.
Thanks!
Ken
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid I wanted to be either a movie director or a chef. I almost went to college for film, but decided on Business School. Luckily I never stopped cooking, started a catering business in college to pay for my tuition and housing. Unfortunately I never continued my culinary career, but like I mentioned I never stopped cooking.
adam.b
