Best Of
Re: January Question of the Month - Join the conversation and receive a badge
My bucket list item is become Smartsheet Certified this year and read one book a month
ChrisJ2025
Re: Negative Number Formatting in Parenthesis
This would go in a helper column for display only. It outputs a text string, so if you have to run calcs on the numbers, you'll want to reference the original column. This also only works as long as your number is less than 1 trillion. There may be a more efficient formula that can be written, but I had to come up with this one in a hurry for a client. It works though, so I haven't spent any more time on it yet.
=IF([Total Column]@row < 0, "(", "") + "$" + IF(LEN(INT(ABS([Total Column]@row))) <= 3, RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 6, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 9, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 12, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 11, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 9)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3))))) + IF([Total Column]@row - INT([Total Column]@row) = 0, ".00", RIGHT([Total Column]@row - INT([Total Column]@row), 3)) + IF([Total Column]@row < 0, ")", "")
Paul Newcome
Re: Dashboard View Restrictions
@Joe Mul You can accomplish this by using the Current User filter in the report builder.
Isis Taylor
Re: Can I use Summary fields in formula
Hello @SueinSpain - The formulas in your columns can reference any of your sheet summary fields. If you have a sheet summary field called "doors", then you would refer to it as doors#. If you have a summary field called "Fire Doors", then you would refer to it as [Fire Doors]#
The pound symbol is the key. Hope that helps! Also for reference: https://www.smartsheet.com/template-gallery/formula-handbook
Scott Peters
Re: コメント機能のメンションを「必須」にしたい
私が言っていることに間違いがあったらご容赦ください。私は英語が母国語で、日本語は1語しか知らないので、Google翻訳を使用しています。
私の自動化では、行が追加されたときのみ、自動化の一番上に「行番号536」などと表示され、ハイパーリンクされています。メールの受信者が編集者以上の場合は、これがメールに記載されているはずです。追加された行に直接移動します。
ただし、変更またはコメントの自動化の場合、これは現在Smartsheetが提供する機能ではありません。フォームまたはコミュニティ機能リクエストページのいずれかから製品フィードバックを追加することをお勧めします。以下にリンクを貼っておきます。
これに関する手順を構築するか、Bridgeアドオンを使用して自動化を作成できる場合は、これを回避する方法があります。
このリンクをシートの列にコピーして自動化で送信するプロセスを実装するか、Bridgeをお持ちの場合はこれを自動化できます。写真を参照してください。行のリンク情報を取得するには、行の左端にある 3 つのドット メニューをクリックします。コメントと添付ファイルの画像のすぐ隣にあります。
Bridge を使用する場合は、この情報を自動的に検索し、ハイパーリンクとして列に貼り付ける自動化を作成できます。
これで質問の答えが見つかった場合はお知らせください。
Re: Automated emails outside of smartsheet users
Workflows are an amazing tool to automate manual tasks! To set up an automation to the students individual email when a status is changed, please see below:
Step 1: Ensure Your Sheet is Set Up Correctly
- Verify Columns:
- Student Email: Contains each student’s email address.
- Status: Tracks the status for each student (e.g., "Pending," "Accepted," "Rejected").
- Trigger Column (Optional): If needed, create a helper column to further refine when an email is sent.
Step 2: Create an Automation Rule
- Open your sheet and go to Automation in the top menu bar.
- Select Create a Workflow or Manage Workflows.
- Choose Custom Workflow.
Step 3: Configure the Trigger
- In the automation editor, select Trigger.
- Choose When rows are changed.
- Set it to trigger when the Status column is updated.
Step 4: Set Conditions (Optional)
- Add conditions to filter which rows trigger the email:
- For example, "Status is 'Accepted'" or "Status changes from 'Pending' to 'Rejected'."
- Click + Condition to specify these filters.
Step 5: Add the Action
- Under Action, select Alert Someone or Request an Update (for more interactive emails).
- In the Recipient field:
- Choose the column containing student emails (e.g.,
[Student Email]).
- Choose the column containing student emails (e.g.,
- Customize the email content:
- Add dynamic fields using placeholders (e.g., “Dear {Student Name}, your status has changed to {Status}.”).
- Include additional details if needed, like deadlines or next steps.
Step 6: Test the Workflow
- Manually change the status for a test row to ensure the email is sent correctly.
- Verify the email content and formatting in the student's inbox.
Step 7: Save and Activate
- Click Save to finalize the workflow.
- Ensure the workflow is toggled ON to activate it.
Please let me know if this helped you out!
Thank you,
Re: Copying data from one sheet to another
You can't do it with core smartsheet automations, but if you have access to Smartsheet Datamesh or Bridge you could use those.
Alternatively you could use a third party solution like SmartLink.
Darren Mullen
Re: [RECAP] The Power of Authenticity in the Creator Economy
Such a good episode! Feeling very inspired.
Alison C.
[RECAP] The Power of Authenticity in the Creator Economy
Hi Community,
If you've ever been curious about the creator economy, this episode of the Brand Collective podcast is exactly what you need.
Meet Jamie Chicoine Chartier and Lucrèce Sicat Loe, Amazon Europe’s Head of Creator Marketing and Head of Influencer BD. Their combined expertise makes them the perfect guests to introduce us to this fascinating world!
Here’s what you can expect:
- Find out why keeping it real matters to content creators’ growth.
- Learn how niche branding helps creators stand out, spark connection, and grow communities that care.
- Unpack the global differences in the creator economy, from audience engagement strategies to brand partnerships.
🎧 Join the conversation. Name a creator that truly feels relatable and authentic to you.
On the episode, Jamie and Lucrèce share many reasons why customers trust creators who are honest and human. Think of the content creators you enjoy — Who is a great example of those characteristics?
Happy listening!
---
Want to check out more Podcast Recaps? Find them all here. ✨
Rebeca S.