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 March 2017
Discussion List
Automate RYG balls when a check box is ticked in one colum only out of three columns
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
Batch Update Request
I would like to send update requests for different rows to the 'assigned to' field in a batch request. Multiple update requests at one time. My specific purpose is to send out requests for proposals and collect PDF responses along with other information about the proposal and template the process to apply to multiple…
How do you change or delete a recurring email on a Report?
I set up a report to be emailed automatically each week and the PDF puts the overflow onto separate pages, so I would like to change (to Excel) or delete that recurring email. I can't find where to do that.
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
IF formula to generate deadline
Hello, I am looking to create an IF formula that would generate an upcoming deadline automatically based on two factors. The first is a customer dropdown selection row and the second being the submission date of the item. Such that if a certain customer is selected a due date will be generated 10 days from the submission…
Send an email when assigned task
Hello, Is there a way to have an email sent to someone when they are assigned a task. For example if there was a task that was assigned to nate, and it now gets re-assigned to dave can the system send dave an email? - Adam
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
Enhanced Color Options?
It would be really great to have more color options for formatting our Smartsheets. Having a color picker that presents a broader range of colors or allows us to enter Hex codes or RGB codes would be a really helpful enhancement as some of the default colors are too bright or distracting. Having the ability to modify the…
Importing multiple rows into a webform
I need to get stock declarations from a supplier for about 12 items into a sheet. I would like to send him a webform each week that he can complete and submit back and that will in turn populate 12 new rows in a smartsheet. I would then use the update to update a master stock list sheet (using Azuqua). But I need to have…
Smartsheet jira connector row issue
Hi all, I have a project sheet which is connected to jira. Everytime the connector gets updated some of the rows that i have arranged/sorted get moved in smarsheet. Is there a way where i can fix the rows in one place and only the fields can get updated when the connector is updated. The locking row option doesnt help…