Best Of

Re: March Question of the Month - Join the conversation and receive a badge

One skill I'd like to improve in relation to health and Crohn's disease would be a deeper understanding of how diet and nutrition impact the disease. While I know that Crohn's disease is an inflammatory bowel condition, I would love to learn more about which specific foods and nutrients can help manage symptoms or even reduce flare-ups. There’s a lot of research out there, and understanding the nuanced relationship between food, the microbiome, and immune response in Crohn's could be incredibly helpful for those managing the condition.

AngB789

2 ·

Re: March Question of the Month - Join the conversation and receive a badge

Great question! The one skill I’d like to improve is the ability to be more understanding rather than always trying to be understood.

Yvonne Smythe

5 ·

Re: Help with COUNTIFS function

Thanks. The ranges are in the same sheet so not sure why the formula reference is showing two different names. I tried to recreate the table from scratch, and it seems to be working with the formula you provided. Your help is much appreciated

Eric Hall

1 ·

Re: Count Project Categories + Count if Before a date

Try:

=COUNTIFS([Project Category]:[Project Category], AND(@cell <> "Complete", @cell <> "With Consultant"))

Paul Newcome

1 ·

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

1 ·

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

4 ·

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

1 ·

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

1 ·

Re: March Question of the Month - Join the conversation and receive a badge

My ability to listen

Monicacraven

5 ·

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

1 ·