-
Count Crime Rubric Score
Hi, I am attempting to count three cells Crime Rate Score + Area Affected Score + Intangibles Score and have the overall score reflected in the Rubric Score cell. Using the following formula: =SUM([Crime Rate Score]@row, [Area Affected Score]@row, [Intangibles Score]@row) However, after converting to a column formula the…
-
Please allow adding or updating forms template sheets that can be updated via global updates.
-
Reporting: Multi-Select Data, Best Practice?
I have a multi-select column I'm trying to count instances of for each quarter of each year. I created a make-shift report using a sheet and I'm looking for help to determine if there's a better way to do this. Report I created: I've duplicated that sheet into more columns so I could share the formulas I am using. The left…
-
Lock single cell
Hi SM Team, What's the latest for this feature ? Is it possible to lock a single cell ? Thanks in advance for your answer
-
Remove "1 row added" type wording from notification emails
Have an option to remove the details section that sends with automation notification emails and instead just show the fields
-
Smartsheet to Microsoft Copilot Connectivity?
When can we expect a Copilot / Microsoft 365 graph connector / plugin to support Smartsheet - Copilot connectivity? e.g. Multi-turn demo using Atlassian plugins for Microsoft 365 Copilot (youtube.com)
-
Form submissions not showing up in grid view
Hello! I am using smartsheet forms for registration and when I open the sheet in grid view it is blank but it is saying that there are 51 form submissions and they are showing up in card view. I am at a loss as to why it is not populating. I have never had this issue before. Thank you, Erin
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
-
JOIN is missing items when joining multi-select dropdown column
I have a dropdown column (multi-select) that lists participating districts. Each row is a different program that can have different districts or sometimes the districts repeat. I am trying to count how many unique districts participated. In a separate column (dropdown - multi-select), I am trying to use JOIN to pull all…
-
Smartsheet Glossary
I would have loved if there was a Glossary of Smartsheet terms (instead of having to Google them, one by one) back when I was in Training. Quick definitions of terms such as API, Workflow, Assets, Connectors, etc.
