Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for November 2017
Discussion List
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
Number of rows in a sight.
I have a sheet with just under 500 rows, with information about buildings. I have a report to format a concise list of information to publish, and have several widgets, including links to the maps that have some of the source data, on my sight. The Sight only displays the first 150 buildings, with a pop-up link to the…
Trying to work around the 5000 row limit
Hi Guys, I know there are other questions on this, such as here: https://community.smartsheet.com/discussion/rss-feed But in the interests of etiquette I thought I better start my own thread. So I have a sheet where I add a new row at the top. Every three months or so I reach the 5000 row limit and have to move rows out…
Filtering out data from an equation
Hello, Is there a way to filter out specific data items from an equation? Specifically I am creating a sumifs formula and I would like to be able to filter out fiscal year data without making it a condition of the formula, that way we wont have to change the formula every year. I have a column that shows the fiscal year as…
Sharing Permissions and User Types Explained
Hi Smartsheet Community, We just recently released an Infographic in the Help Center to take on the sometimes confusing territory of account types and sharing permission levels. Here's the link: Infographic: User Types and Sharing Permissions Explained This is the first time we've done one of these in the Help Center, so…
Conditional Drop-down list
Good afternoon, Currently, my company is using smartsheet to build up a database of our quality issues. Since the department is new to this, data entered is not very robust: Many auditors simply log in, type in their name, work station and enter text describing issues as they encounter them. I want to take this to the next…
Will Smartsheet load my template items into JIRA?
I have a template I will use to kickoff projects that will have JIRA tickets in them. Can I copy and paste these rows into smartsheet once I have updated them so smartsheet can start the ticket in JIRA, via our connector? I am guessing I have to make the JIRA connection in a new sheet and then copy and paste my template…
Does Smartsheet to JIRA work with existing sheets & tickets?
I have an existing sheet that I want to use my new Smartsheet to JIRA connector. However, I cannot figure out how to link my exiting JIRA tickets which I have by URL already in smarsheet. Can this be done?
Sum Costs by Quarter
I have purchase requests coming to me from a smartsheet form and it is capturing costs of each request. I have a "created on" column open in the sheet. I would like to sum costs of all requests per quarter. This information is being captured in a sight and broken down into quarters and Year to Date on the sight for 2017. A…
Date Formula
I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart sheets equivalent. Can someone help me?