Best Of
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is the supercharged tool you need for collaboration and project/work management that has all the features and functions of MS Excel / Google Sheets / MS Project / Trello, but with its own amazing benefits.
SteCoxy
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is like a spreadsheet on steroids—supercharged with project management powers so you can organize, track, and automate your work without losing your mind.
AngB789
Re: Hello how can I produce percentage through the reports Data that are not percentage
thank you so much :))))))
Gaia Amaia
Re: March Question of the Month - Join the conversation and receive a badge
Have you considered using an AI tool? Some apps used to run meetings have built-in AI tool to take notes
AntonioC
Re: Symbol Flexibility - more symbol colors/options
Hi @donna.yong3292,
It looks like you used the Product Feedback Form to submit your suggestion. This form should be used for feedback you have on existing features in Smartsheet.
The process for requesting enhancements is to post an idea in the Smartsheet Product Feedback and Ideas topic here in the Community, just like this thread. Have you added your vote on the top level comment for this thread? You can see that status of the request there, and that status will be changed whenever we have further updates.
Hope that helps!
Georgie
Georgie
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