-
Can I use Summary fields in formula
I have created some sheet summary fields to count the number of records that meet a specific criteria e.g. Fire Doors - Pass is the summary field and the formula is =COUNTIFS([Last Month]:[Last Month], ="True", [Fire Doors]:[Fire Doors], ="Yes") I have done the same for several other fields too e.g. Fire Exit Routes -…
-
Contact List and Drop down List values can be referred using a reference from a different sheet
For Contact List and Drop-down list columns currently the values need to be added and updated individually in all columns and sheets eventhough the values are common for many columns and sheets. If we have a provision to have the values referred using a reference from a different sheet, then we can add or update the values…
-
Can Not @Mention in Comments
I have an unlicensed user who is shared to a workspace as Editor. She is trying to use @mention in the Conversations but it will not populate with the person she is trying to @mention. Is this because she is unlicensed? I can not find any information in Smartsheet Help that would restrict this.
-
DataMesh & Locked columns
Hello, Will Data Mesh still import appropriately if the some columns in the target sheet are now locked?
-
How do I freeze columns in a report on a dashboard?
I'm trying to include a report on a dashboard, but I can't seem to figure out a way to freeze columns when the report is on the dashboard. Is there a way to do this? Any suggestions are greatly appreciated.
-
Formula for duplicates including time
This discussion was created from comments split from: Formula for Duplicate Entries.
-
Report column groupings showing text under the grouping name
I am attempting to create a report that groups ticket IDs by the report name. The grouping is based on the column named "Report Name Internal (Final)" and the undesired text being displayed is from the primary column. The grouping name displays text from the primary column below the report name. What's odd is the undesired…
-
Bug in the Smartsheet Reports
I noticed that sometimes when in reports I use Grouping there is some faulty data showing up (partially covered) - such data is not even part of this report. Whenever I refreshed the report in the browser the proper grouping was set up again and unwanted data disappeared. Today the customer came to me telling that it's bit…
-
コメント機能のメンションを「必須」にしたい
Smartsheetを用いて、案件のレビューを行っております。 提案者がフォームから「レビューシート」に案件情報を入力すると、レビュアーにレビュー要請のメールが届きます。 レビュアーと提案者の質疑はコメント機能を使って進めています。 この中で二点、課題があるので何か良い改善点があればご教示いただきたいです。 ①コメントのメンションを「必須」にしたい コメントにてレビュアーからの質問の入力および、PIからの返答に当たっては運用ルールとして「相手をメンションすること」としておりますが、(お恥ずかしいことですが)なかなか徹底されません…。…
-
Adding Images in Form Body and Descriptions
Currently, I am using Google form to capture responses because of the easy creation logic using section builder and adding images to the questions. It would be great if the smartsheet form had the same capability as google form with easy creation of logical questions by adding images with the questions.