-
What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
-
How can I connect project names to a project #?
I am looking for a better way besides individually making automations. That allows me to connect multiple project names using a drop-down list to a specific project number.
-
Proofing - Office Documents
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
-
Sorted column keeps resetting
We're using forms to gather requests into a smartsheet and the default sort should show the newest request first. There is a Created (Date) System column in order to sort by newest received but the sort continues to glitch each time the sheet is closed and it defaults to sort oldest to newest. This is creating some…
-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
-
Replying to External Emails Workflow
Greetings, I was looking for a workflow that would allow us to reply to tickets from external accounts/emails that come in via the form from the 'IT Requests and Ticketing' template sheet. We'll be getting frequent back and forth correspondence and that external email should not have access to the entire sheet (only a…
-
Searching within a large dropdown list
Hello, I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of accounts and I would like to know if there is a way to broaden the search within the drop…
-
Using an OR in COLLECT
Hello - I'm trying to use an OR operator in the criteria of a collect function. This is currently returning an #INCORRECT ARGUMENT SET: =IFERROR(INDEX(COLLECT({WAP Deposit Number}, {WAP Date}, Date147, {WAP Type}, OR("CHECK", "CREDIT"), 1), "")) I'm trying to return the a deposit number {WAP Deposit Number} if the Date…
-
Can I link a Smartsheet dashboard to a sharepoint page? Please read the task below:
I am trying to link a Smartsheet dashboard to a Sharepoint page but this Smartsheet is edited twice a year and specific people need access to modify and then the rest of the business needs access to just view. How do I do this?
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?