-
Dynamic View
Is there a way to use the @name feature in the comments section of dynamic view? This is a great feature in the sheets but doesn't work for whatever reason in the dynamic view.
-
Dashboard Reports & Row Attachments
Hi! I was wondering if there might be a way to display the "attachments" or "comments" column of a report via the report widget when working on a dashboard? Essentially, I would love to be able to see if/when a row has either a comment or attachment linked to it via the dashboard. It would be even more amazing if that…
-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…
-
Creating a form with Multiple Logics
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data. I would love to use the same form, select from the drop down and the fields auto-populate. But I am getting this error. Is there a limit? Or is the error because I am selecting the same…
-
Moving rows to new sheet with proofing enabled
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartSheet (including the proofs) but we are unable to do so. Is there a work-around solution…
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
-
Task list for a card view? (like trello?)
We currently use a portfolio sheet that tracks our pipeline of clients and organizes them by stages. We love this sheet as it provides us with very useful management level information. However, it does not allows us to manage the "work". It just gives us an overview - which is the intention. To manage the work, we have…
-
Hierarchical numbering patterns?
Anyone with experience setting up hierarchical numbering schemes? I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example 1. Row 1 --1.1 sub item of row 1 ---1.1.1 sub item of row 1.1 ---1.1.2 sub item of row 1.1 ---1.1.3…
-
Using Dashboard to run meeting - Ideas to add in a timer?
Hello! Using a Dashboard to run our weekly meetings and had an idea to add in a timer inside the dashboard to stay aware of how much time we have left to discuss each topic. Smartsheet doesn't allow any domain that I know of that can allow me to embed a timer... So I tried a workaround. Embeded a Google Data Studio Report,…