-
Create a Map chart?
I'm looking to create a map chart within a dashboard (namely, a chart of the United States, with data in each state visible when hovering over each state). Has anyone done this that can point me to where to get this done? I've seen them in Excel, but have had no luck for this capability in Smartsheet.
-
How do I set an automation without a trigger or is there a workaround to create a trigger
Hello! I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time period after it is locked by the first automation. Essentially I want to ensure that…
-
Is there a formula in smartsheet that would create a 2 way link between cells?
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet.…
-
How to add primary column to report
I am unable to click the 'columns' button at the top right when creating a report and add the primary column. Down below that in the filtered section it will let me add it, but not data shows up. It is a free text field where the guys on the job type in their notes from that day's work. I would like it to report out so…
-
Automation triggered by an email
Hi, Can I send an email to a Smartsheet, whereafter the Smartsheet does this: 1, locate textstring in email. 2, compare text with row. 3, send email or textmessage to a person in a contact cell in that row??, Thanks in advance /Poul.
-
Dashboards on rows
Hello Everyone, I am trying to build a Dashboard, several teams in my Org. can use. The idea behind this is as follows: There is a separate sheet, which gets filled by using forms / row update. Each Team fills out their row initially by using the form and then does updates on certain fields via a workflow. A Dashboard…
-
With COUNTM I can determine multiple selections are made, how can I extract the specifc selections?
If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or CONTAINS and looking for names one at time?
-
Updating Existing Row from Form Data
Hi - I have a request to create a sheet where a team member wants to input data, and then send a form link out for additional information to be collected. We would all of this information to be populated on one line Does anyone know if this is possible, and if so, how to do it? Thank you! Sheryl Sheldon Cincinnati…
-
Referencing a cell on another sheet based on information in its' parent
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with…
-
Is there a way to customize the submission confirmation page?
I have built an audit for the operations folks to fill out and submit via Forms. They are wanting to have their score automatically appear on the submission confirmation page so a few questions: Is that possible? If it is possible, how do I build that feature in and what sheets, formulas, etc. are required?