Best Of
Re: Automatically Sort Rows in Sheets
As suggested by @Genevieve P. , I switched to Table View and found that sorting is available, but only for a single column at a time. I need sorting across multiple columns. This seems like a step backwards, not an improvement. Am I missing something?
Re: Automatically Sort Rows in Sheets
Glad it's in Table View, but we cannot yet use that view. Thus, the issue remains for Grid View which being a legacy platform, I'm saddened it wasn't included in the feature. I have to resort various grid sheets multiple times a day which eats away at valuable time.
Loann McGee
Re: Using If and Iferror together
This should do it⦠you were close.
=IFERROR(IF([Due Date]@row - TODAY() < 0, "Calibration EXPIRED", [Due Date]@row - TODAY()), "No Due Date")
Carson Penticuff
Re: Multiple hyperlinks in a cell
I also have the need to put two or three hyperlinks within the same cell.Β PLEASE add this feature, Smartsheet!
Re: Multiple hyperlinks in a cell
I need this functionality as well. It would be VERY useful.
Re: Ability to Find & Replace text in Formulas
I have a Smartsheet Metrics file with a lot of formulas. I understand if the Metrics sheet is provisioned with Control Center, this would accommodate the functionality I'm looking for. In my case, the sheet is not provisioned with Control Center as it is pertinent to our overall Portfolio of initiatives and not just the Active initiatives managed within Control Center. I am looking for the equivalent of a "Find and Replace" function to update all formulas in the sheet. The current Find and Replace doesn't work for formulas. I realize the workaround would be to create a "Helper" column for the replacement, but would prefer not to create these columns.
Re: Jira and Salesforce Connectors - Include Attachments
This is exactly the idea that my development team and I wanted to share - the risk of missing attachments is pretty high when one team works in Jira and the form is in Smartsheet.
API Bulk support for Delete Group Members
Currently the Delete Group Members endpoint only supports a single userId. It would be very helpful to support Bulk semantics so we can pass along a list of users at once, similar to adding users to a Group.
Default sorting of attachments
Good afternoon,
Is there a way to set the default sort for attachments? Currently it is by date and we'd like the default to be by name.
Blessings,
Loann
Loann McGee