Best Of
Re: ガントチャートについて
ガントビューで特定の期間だけタスクバーの色を変更する方法についてお答えします。
Smartsheetでは、タスクバー全体の色を変更する機能はありますが、特定の期間だけ色を変更する直接的な方法は提供されていません。しかし、以下の方法で目的を達成することができます：
- サブタスクを作成する:
- 1年間のタスクを複数のサブタスクに分割します。例えば、11月と12月の期間を別々のサブタスクとして設定します。
- 各サブタスクに対して異なる色を設定することで、特定の期間だけ色を変更することができます。
- ハイライト機能を使用する:
- 特定の期間をハイライトするために、カスタムフィールドを作成し、条件付き書式を設定します。
- 例えば、11月と12月の期間に対して特定の条件を設定し、その期間だけ背景色を変更することができます。
- コメントやシンボルを使用する:
- 特定の期間に対してコメントを追加したり、シンボルを使用して視覚的に強調することも一つの方法です。
これらの方法を試してみてください。もし他に質問があれば、いつでもお知らせください！
Naeem Ejaz
Re: Weekly rotating roles formulas
@jmyzk_cloudsmart_jp Thank you so much for all this work! I really appreciate it. I'll give it a try. This really helps.
mtp105
Re: Can someone please help me to get the duration in minutes for a start date time and end date time?
You can use the TIME function to convert AM/PM time format to 24 format, which makes it easy to calculate duration minutes.
[Time 24] =TIME(RIGHT([Date Time]@row, 8), 1)
[Year] =VALUE(MID([Date Time]@row, 7, 2))+2000
[Month] =VALUE(LEFT([Date Time]@row, 2))
[Day] =VALUE(MID([Date Time]@row, 4, 2))
[Date] =DATE(Year@row, Month@row, Day@row)
[Hour] =VALUE(LEFT([Time 24]@row, 2))
[Minitues] =VALUE(RIGHT([Time 24]@row, 2))
[Time Minutes] =Hour@row * 60 + Minitues@row[Duration: Total in miniutes]# =[Duration: Dates]# * 24 * 60 + [Duration: Minutes]#
format—[optional] [optional] Specifies whether the time is displayed using a 12-hour (0) or 24-hour (1) clock.
Re: March Question of the Month - Join the conversation and receive a badge
As a parent of 3 children. 10, 4, and 2. I want to improve my skill in helping them learn and grow. To teach them to do and be better then I did or was.
Mark.poole
Re: URL String Query for Column Type: Contact List
If you just use the email address as the pre-fill value won't it show the display name(s) correctly when matched?
Adam Murphy
Re: SOP Document Review and Approval Workflow Tracking
Yes, Smartsheet offers several templates that can help you set up a project collaboration platform with the features you need. Here are a few templates that might be useful:
- Project Management Office (PMO) Template Set:
- This template set allows you to track and approve new projects while seeing key metrics across all projects in real time. It includes features for planning, tracking, and reporting on multiple projects.
- Project Tracking & Rollup Template Set:
- This set includes pre-built sheets, reports, and dashboards designed to help you manage project tasks, stay on top of deadlines, and access project information through a Project Rollup Dashboard.
- Project with Gantt & Dependencies Template:
- This template helps you plan, track, and manage your project with a visual, interactive timeline. You can attach supporting documents and identify the impact of task delays.
To customize these templates for your specific needs:
- Attach Document Links:
- Use the attachment feature in Smartsheet to add document links to your rows.
- Request Review from Stakeholders:
- Use the Request an Update action in your automation workflow to send review requests to stakeholders. They don't need a Smartsheet license to respond.
- Send Documents to Multiple Stakeholders:
- Set up multiple approval workflows. Once the first level of review is completed, capture the approval and trigger the next level of review.
- Email Notifications:
- Configure your automation workflows to send email notifications when documents are approved or rejected at any level.
Naeem Ejaz
Re: Display Tasks for the week
Hi @Andrea Westrich ,
I think this might work for you.
You can add another column to the sheet that has this formula:
=IF(WEEKNUMBER([Due date]@row) = WEEKNUMBER(TODAY()), "This week", "-")
Then on the report you can filter by that column:
Hope it works for you,
Sam
Sam M.
Re: CountIF contains name from a contact list help needed
Hey @SSParks !
Try adding HAS to your formula like:
=COUNTIFS({Community Requests Range 10}, HAS(@cell, "Justin Crawford"), {Community Requests Range 11}, YEAR(TODAY()))
AKnight
Re: Data Shuttle filter logic
A few questions and things to consider:
—Does your input file include column headers? If so, make sure you set that up.
—Does your workflow point to the correct tab on your input file? Doublecheck that.
—Is your Shuttle workflow set up to Replace all target sheet rows with the data from the input file, or Merge data into the target based on a key column value? If the latter… is your target sheet blank? For some reason, this tends to present an issue for me at least. Perhaps manually add a row or two before trying to run it.
This is by no means a comprehensive list, but will get you going down the troubleshooting path. Good luck!
Kerry St. Thomas
Smartsheet Forward 2025 Edition 1: Innovations to help you collaborate, automate and get work done
As we kicked off 2025, with the Jumpstart 2025 with Community event, many of you reflected on your goals for the new year. With workflows growing more complex—more tasks, dependencies, and content to coordinate — the latest issue of Smartsheet Forward couldn’t be more timely.
In this issue you’ll hear about how we’re continuing to evolve Smartsheet into a platform that doesn’t just respond to needs but anticipates them. Learn about how our upcoming AI and collaboration innovations are making it easier to collaborate, automate and get work done. Get all the details here.
Key topics include:
- Easier work Management with AI
- Improved Collaboration with content, conversations and work in one place
- Enterprise-grade connections with smooth integrations and smarter insights
And more…
Learn how we’re making Smartsheet more intelligent, more connected, and more powerful — so you can focus on impact, not inefficiencies. Learn what’s new.
And please don’t forget to tell us what you think by sharing a comment below, by submitting your product feedback and ideas or voting on ideas shared by your peers.
Arsineh