Discussion List
Seeking Automation Solution for Linking Cells from Multiple Sheets to Master Sheet in Smartsheet
I'm looking for a way to streamline the process of linking cells from different sheets to a master sheet in Smartsheet. The master sheet, 'Project Dashboard,' contains 15 columns where linked cells need to be added. Each project has a unique 'Project Plan' sheet with identical formats but different dates. How can I…
In CARD view, my contact card OWNER column is not listed as a "VIEW BY" option
I have a sheet that has assigned owners. The owner column is a Contact list type. Contacts are added individually via the column property window. However, I in CARD view, I OWNER isn't an option under VIEW BY. When I edit the lane to add OWNER, it says "Column name is already in use in this sheet"
SUM(IFERROR(INDEX(COLLECT(MATCH))))
This discussion was created from comments split from: SUM(IFERROR(INDEX(COLLECT(MATCH)))).
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
Accumulative Formula Required
Hello! We require a formula that calculates the PRODUCTION PACE for the completed builds in a financial year quarter. Currently we have the Pace calculating off the completed builds/ number of days in the qtr, but this means that the pace is really high compared to how often we are actually completing a build. I want to…
Parent Field Added to Smartsheet Jira Connector
Hi Community, To support the new Parent field within Jira, we have added the Parent field for Jira Cloud and on-prem workflows. For Jira on-prem workflows, you can now select the Parent field (bi-directional) in addition to the Epic Link (bi-directional) and Parent Link (uni-directional) fields within the Jira Connector.…
Separate reply-to email address for auto emails
Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…
NEW Help Article! Create dynamic dropdowns with Data Shuttle
Hi Community, Did you know that you can use Data Shuttle to create dynamic dropdowns? Dynamic dropdowns with Data Shuttle can automatically update a dropdown list in one location when that list has changed in another location. I've seen some questions around this in the Community and wanted to call out the new Help Article…
Date & Time
Hello- How do I add the date and time from start of task to end of task from this form? I need to measure the date and time from start to finish. I'm using the FORM. Thanks.
Need to filter the data in dashboard by month
Hi, I have a customer feedback data captured on the Smartsheet, and i have created the dashboard for the same but in dasboard i need to filter the data by month. Is there any way to achieve this?.