Best Of
Allow sheet Summary Reports as a source for Dynamic Views
It would be helpful to be able to share summary field information from multiple projects using Dynamic View and a Summary Report. Summary Reports are an excellent way to share summary field data for multiple projects. Sharing this data using Dynamic View allows the owner/admin to show key fields in a grid, then make additional details available in the details pane, and provides consumers with the option to filter the dataset.
Currently Dynamic View seems broken as it allows users to click on a summary report using the source picker, but then the process hangs after clicking the Create button.
KwGodwin
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic:
If box is checked, then field is required
I spoke with support and they informed me that this is not a currently available feature.
What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they are required to fill out the additional comments field. But, I don't always want the additional comments field required.
BoseLibrarian
Re: Disable License Request Features
It's been described as the Smartsheet Pyramid Scheme... which I thought was REALLY funny... I was JUST talking with a group of my users yesterday - they were all wanting licenses - which they don't need... and I hate having to explain that!
isa.ohara
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)
Leibel S
Communityで人気のコメント
Smartsheet Community （英語版）で人気のコメントのうち、「いいね！」と思ったものをご紹介します。
第１回目は、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.
Marco Moura
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.
MPound
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.
Edward Spencer
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.
Joseph Leroy