Best Of
Re: Return the last number (current month) from a column of numbers
Try this instead:
=INDEX(COLLECT({FP 2024 Calls - by month Total SL%}, {FP 2024 Calls - by month Total SL%}, @cell <> ""), COUNTIFS({FP 2024 Calls - by month Total SL%}, @cell <> ""))
Paul Newcome
Re: Automation: To use multiple condition paths to automate multiple Columns
@Lisa B 2022 You want to know how to create multiple conditions simultaneously?
If you click on the "+" icon in blue, you will get the dropdown list containing:
- Add a Condition
- Add a Condition Path
- Add an Action.
If you click on the "condition path", you'll be able to create a number of condition paths. I believe there is a limitation on how many condition paths you can create.
Tamal Dey
Scroll Bar Size
It would be fantastic if we could either increase the size of the scroll bars (bottom and right) or show them permanently. It can be so frustrating trying to get the scroll bars to engage, especially when referencing another sheet in a formula.
Lisa B 2022
Progress bar values in numbers
Hi
I'd suggest that renaming the progress related words (as shown in the screenshot below) to 0, 25, 50, 75, and 100 would make it much easier to remember and update by just pressing the first number.
For example, if I want to change the progress bar to three quarter, I just ned to type in 7 (which will pull 75%). This is especially more practical because we usually talk about progress in numbers (e.g. 75%), and not three quarter).
This will also help the keyboard freaks!
zealvert
Link to Active Directory
In the "Initiator" field of a form I would like to see it auto linked to Active Directory, so it consistently populates the person's first and last name, title, department, etc.
dwtobias
Re: Bulk Deleting all outstanding update requests
Has this been resolved? I am approaching 1000 updates that need to be closed. I have deleted the Request Update workflows and this will take me 3-4 weeks to resolved manually.
Roy Hilo
Automation: To use multiple condition paths to automate multiple Columns
1. I have created an automation workflow with multiple condition paths.
2. Each condition path is to identify the certain key words in the respective contact a columns mentioned in it.
3. As an action replace the contact containing the key words by 'Action: assign a Contact'
Tamal Dey
Re: Get Date and Time from a column
Hi @Peterson
The automation will work for this.
Go to Automation then use When rows are changed and use the Column where the checkbox e.g Checkbox is checked, record a date in the SLA column. That will record the date when you check the checkbox.
Thanks
Re: Group Management - Sorting Contact List Alphabetically
This is for sorting the members of the group. A simple sort on the column header would suffice. It is impossible to determine who is included or missing from a large group as they are now just displaying in creation order ( I believe).
Smartsheet -this may never get many votes as it is a system admin function. Please consider this even if it is not a high vote getter.
Re: Automatically Sort Rows in Sheets
I would love to see an option in the Automations to trigger a Sort on changes or row adds.
slarijani
