Best Of
AI to Suggest and Explain Best Automation based on Description of Need
Hi Comrades
It would be very useful if the dropdowlist had the option to autofeed if values or names that are not included are added, with this option these dropdownlist would be automatically updated, like the contact lists
Regarding the automations, seeing how the AI is starting to be implemented, it would be very good if you could explain to the AI the type of automation you need and it would provide you with the automation that best suits your needs and explain it, not having to search among the many options that exist.
Best regards
Jacobo
Jira Connector should support syncing the Team field in Jira Cloud
My team are heavy users of the Jira Connector for Smartsheets. My company has recently moved to Jira Cloud. The transition of our connectors has gone fairly smoothly but we have found a few things that do not work the same. We are using the Team field in Jira Cloud extensively to identify work that belongs to teams and groups. We discovered that this field is currently not supported by the Jira Connector and will not sync into a Smartsheet. This is requiring us to re-think the structure of many of our sheets and also impacts our ability to make maximum use of the automated notifications that come out of a Smartsheet.
I think that the team field should be considered a critical field for synchronization form Jira Cloud into a Smartsheet.
Louis
Re: Sights separator lines
Another option would be to edit the title of the widget using the line and then make it bold, adjust font size, etc. That would keep your line the same size as the widget as opposed to having 2 separate ones.
I haven't tested this, but it seems like it should work.
Paul Newcome
Block Publishing Blank Reports
I have reports that get emailed to clients weekly, if they don't have any active projects they are receiving blank reports. Ideally, we would be able to stop blank reports from publishing without having to manually stop/start the recurring email each time they have no active projects and instead Smartsheet could pick up when reports are blank and not send the email.
Aoibhin
Re: March Question of the Month - Join the conversation and receive a badge
My ability to listen
Monicacraven
Batch Convert Attachments to Proofs
I regularly send multiple, separate, files to clients for review and approval. Rather than converting each one and having to invite my client contacts every time, I'd like to select multiple rows and convert them from attachments to proofs, THEN invite my client, in one place.
nmsrs
Allow for Permanent Default Filtering to No Filter
Create an option for a sheet to permanently have the filter set to default, rather than defaulting to the last filter that a user accessed the sheet on (especially for card view), as it can make links from other applications / email impossible to utilize.
cb2013
Re: Copy Parent and Child Rows
Thanks @Genevieve P. . Sadly, that's really painful with a 1500 line project plan and the inability to expand/collapse just a section.
tlharp101
Automation being triggered whenever anything in my row changes, not just the field I specified?
Hi there,
I am having trouble with an automation workflow in Smartsheet, and I am not sure why it is happening. I had this same workflow set up on a different sheet (an older version of our database) and it worked just fine. I'm driving myself crazy trying to figure out why it's not working now.
Basically the automation says that whenever a row on the sheet changes AND when the field "Discovery Call Assignee" changes, it should notify the "Discovery Call Assignee" that they have been assigned to the row item. What's happening is, anytime any piece of data in the row changes, it's sending a new notification to the "Discovery Call Assignee" even though that field hasn't changed. Here's a screenshot of the automation. Can anyone tell me why this is happening? (I'm only showing the top part of the workflow to protect private information, but these are all of the conditions I have set up).
Thanks a million!
Olivia D.
Re: IF INDEX MATCH yielding INVALID DATA or NO MATCH
You never completed the logical test in your if() statement, right now you are saying are telling it to index to a person's name but not telling it what to do as far as a logical test goes. "=if ( "Frank", "yes", "no")"…. is Frank true or false?
I'd recommend the following instead:
=IF(countifs({CT Certs Range 1}, [Instructor Name]@row)>0, "yes", "no")
here you are saying "=if( "Frank" shows up more than 0 times, "yes", "no")"
Also, just fyi, I'd do it as a countifs rather than a simple countif because you may want to add more criteria later and the difference in performance is unlikely to be noticed. But, for the record, countif() would actually be marginally better than countifs().
Jgorsich