Best Of
Re: Do I need to create multiple sheets for the same form?
Excellent!
Happy to help!
Do you mean that you want the name of the person who filed the form or the manager for the submitter?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Workaround for Grouped Reports with multi-select dropdowns
So I believe I found a workaround to allowing for grouping by multiselect contact or dropdown fields:
Say you have two sheets with "Assigned to" of type Contact List as one of the column headers. - One is configured to allow for multiple entries, the other is not:
- Create your report so that you only select the sheet where multiple entries are not allowed for the Assigned To field.
- Go to "group" and you should see "Assigned to" in the list of available fields. Select it. and save your report.
- Then add the second sheet (where multiple selections are allowed for "assigned to") as a source sheet in the report. When you refresh , you should get a message pop up:
Note: - Down side: the Group by will say "Multiple Contacts" instead of the actual name where data is displayed from a sheet where "multiple entries" are allowed for the field in question.
For groups where at least one row entry is from a sheet where multiple entries is not allowed,", the actual group by field name will show:
In the example below the "Test Group Report change to SS" sheet has "contact List - MS" set to allow Multiple selections. while "Test Group Reporting" sheet's "Contact List - MS" column is configured not to allow multiple selections.
If you expand your report and display the group by field, then you can see the entries for those groupsing that show "Multiple contacts".
Hope this helps others.
Nel Cairns
Re: How can I get Smartsheet to populate the profile image from someone's email address?
You MIGHT be able to do this through the API, but I do know it can't be done within the core product other than manually.
I just checked the API documentation, and it doesn't look like you can pull the picture (which in turn means you can't place it either). Looks like we are stuck with a manual process.
Paul Newcome
Re: Publishing a dashboard, "owners account" definition?
The term "owner" in this instance is referring to the owner of the Smartsheet item in question (dashboard here). So they are referring to anyone else that is also part of the same enterprise account that you are a part of.
Paul Newcome
Re: VLOOKUP for a date within a referenced row of matching username
The formula in the helper column would be:
=PARENT(userName@row)
Paul Newcome
Re: VLOOKUP for a date within a referenced row of matching username
It will have to be present in every row. If you are worried about keeping the sheet clean, you can use a helper column to pull the user name into every row based on the parent cell, hide the column, then reference this helper column in your MAX/COLLECT.
Paul Newcome
Re: VLOOKUP for a date within a referenced row of matching username
You need a MAX/COLLECT combo instead of those IFs.
=MAX(COLLECT({Date Column}, {User Column}, @cell = userName@row))
Paul Newcome
Re: Group WorkSpaces and organize them in "folders"
This is one I put in as well. This is VERY important. There are too many workspaces that it becomes hard to navigate.
Joe Goetschel
Re: Average with criteria
Hi @TorAtle Myrmel,
If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:
=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])
Example:
Hope this helps, but if you've any questions or comments then just post! 😊
Nick Korna
Re: Run a formula if a cell is "not" blank
Hi,
I hope you're well and safe!
Try something like this.
=IF([COMMODITY CODE]@row<>"", LEFT([COMMODITY CODE]@row, FIND("*", [COMMODITY CODE]@row) - 1)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå