-
Celling Linking-Multiple rows
I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory Price Sheet and select the cell I need linked to ALL 50 cells. Using this process it…
-
Do any other companies utilize Smartsheet for Weekly/Monthly Status Reports?
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track. At a high level, each week an employee completes a status report on the projects/tasks they are working on or have completed. Our requirements would include: Have…
-
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…
