Hi, I would like to share multiple templates that I have designed so others can use within my company. Does Smartsheet have the capability to share a blank template?
Hello - I am new to Actions and Alerts. I would like to set up a workflow to allow our team to submit travel requests for their managers for approval. I have my form and sheet set up fine, and the workflow seems to be working correctly and notifying the indicated approver via e-mail. However, it looks like the approver…
We need to track the actual time spent on each task (daily and/or weekly) in addition to the percentage completed (gantt) . Any ideas how I can configure that?
Hello, My team is looking to connect with other Smartsheet users to share ideas on how we leverage Smartsheet to manage tasks and projects. Now that our department is growing, it is crucial that we refine our Smartsheet work space and how we organize our work in portfolio style for each team: operational tasks versus…
Community, as an official sponsor of McLaren F1, Smartsheet has been given a permanent spot for our logo on their cars. But during the upcoming Australian Grand Prix on April 10, it's not our logo that you'll see. We're giving our spot to DeadlyScience, an Australian nonprofit that provides STEM resources and learning…
Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. For example: This formula gives me 13 counts: =COUNTIFS([Curatorial…
Hi all, I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in from another sheet (there was much rejoicing!) but now am needing to be able to edit the info. Is there a way to do that…
Hi there! Has anyone tried this? We have one case for each row and they have basic open and closed statuses. Higher management wants to get involved in monitoring the list when the number of open cases goes above a count of 300. I added a hidden column with an if statement that will turn 1 when the number of open cases…
Above is the sheet I am working with. I am keeping track of a weekly score for each student and want to try and pull previous weeks scores into the current week row so I can track scores over the past month for a specific student. Currently the formula I am using to pull the previous week score into the column 'LastWk' is…
When I delete a person from the system (end of contract), is the person that also deleted from all the automation rules? - I get a large number of messages that a "workflow has become invalid". Thanks for any advice.