Best Of
Re: Provide users with the ability to Print a Grouped Report
I've now lost interest, and don't believe it'll ever be resolved. It's a shame. To have this bug outstanding for 2+ years is pathetic.
Richard Heath
Re: The Smartsheet Community Goes Global! Spanish, German, and Japanese topics now available
gracias!!!!!!
Re: Disable License Request Features
The only response we have seen in the last few months was a note from SS stating "We think it's important to make sure our unlicensed users have a clear path to requesting a license", which is a total BS answer that they are trying to drum up business in a way that bypasses Enterprise licensing policies and is causing bad will with all of us admins who now have to have discussions with end users that we shouldn't need to have. We don't have these discussions with our O365 or other cloud-based users concerning their licensing plans.
JoeKinne
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