Best Of
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å
Re: Run a formula if a cell is "not" blank
Excellent!
Happy to help!
✅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: Can I create a report from google sheet file?
Hi @Marcin4q
I hope you're well and safe!
This is a perfect use case for the Premium App, Data Shuttle.
Is that an option?
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å