Best Of
Re: Multilingual forms
Hi @SmartWay360
I hope you're well and safe!
I can only see it working if the web engine senses the country and shows different pages with your various language forms.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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!
Re: Give Administrators full vision and access to all sheets
@Jesse Crandall they must use the Assume-User header. Also if a user has left the organization it is best practice to transfer their owned items to a new user, which can be done in User admin. If they transferred it prior to leaving you would have to know who it was transferred to unless their account still has access to it.
Re: Send Dashboard via email - manually and automated workflow
This feature would be a huge plus - those at the Admin level appreciate this type of view the most!
Re: Send Dashboard via email - manually and automated workflow
I'm in favor of sending a copy of the dashboard automatically at a certain frequency like you can for reports.
Re: Send Dashboard via email - manually and automated workflow
Thanks @Libby T ! I really appreciate your support. It's on the roadmap, so every comment and vote up helps increase the likelihood we'll see it soon. Please encourage all the community members you know to also come vote this up. Have a great afternoon and weekend!
Task Completion Percentages
So I have a pretty basic Smartsheet tracker with set of Goals (parent) and group of initiatives(children) taken to fulfill the required goal. I am looking for ways on how to calculate the Completion percentages of goals...
I was looking for something in combination of Time bound, No of child initiatives completed..
Is it possible in Smartsheet's or what other metric we can use to calculate the percentage completion..
I know its a pretty generic but I am looking forward for ideas and any inputs are most welcome
Re: Mouse-over / Alt-text to Dashboard Widgets
A new accessibility law in Colorado (US) is scheduled to be implemented July 1, 2024, that requires all Colorado government entities to meet technology accessibility standards including alt text for images. We use Smartsheet dashboards on our website but will need to look for a different platform if accessibility requirements cannot be met. See
Re: COUNTIF AND for data in 2 columns
Hi Diana! Woo-hoo, time to use new "Analyze Data" feature of Smartsheet!
I made some dummy data to test your scenario:
Then I did 3 things shown on next image:
- Click "Analyze Data" icon on far right-hand toolbar
- Prompt; "How many Devices of each type are in each Location?" [it works its magic, spits out the chart]
- Hover over any Location and Device part of the chart to see the number of devices!
I'm answering you this way, as I find myself using this super-cool feature all. the. time., but if you still need a formulaic way to do this without the AI stuff, let me know and I can help with that too!
Best,
Will
Project Status Report > Horizontal View
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in layout. Below is an image of our desired output.
I have searched other questions for a recent solve, but not seeing anything exactly like we are looking for. Any recommendations for how we can easily solve for this? We unfortunately need to find a quick solve, so hoping there are existing templates or formulas we could easily implement.
Re: Is this a Bug or a Feature?
I would imagine this is intended but could still be improved upon.
With the single select, it is assumed "or" when you select multiple values for the trigger. Since a multi-select can have multiple values already, we would have to be able to specify if the trigger is for changing to
one of those things
multiple selections where one of those things is selected
multiple selections where all of those things are selected
multiple selections where some of those things are selected
so on and so forth.
You would need multiple arguments such as contains, is one of, etc., and has a variable and/or functionality. All of these things are already built into conditions, so it just makes sense from a programming perspective to leverage what is already there.