-
Assigning people to tasks randomly and with a condition
Hello, I would like to randomly assign service representatives tasks, but only those who meet the criteria of already completing a task previously assigned to them. I would like to create a workflow or formula that would assign individuals on their availability and at random. Any suggestions?
-
Symbol magically appears in a cell that is copied over to another sheet
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Unable to remove Smartsheets workspace
Hello! A year or two ago I added a workspace for the Smartsheet Mobilizer Kit v2 - a prepackage workspace that came directly from Smartsheets. I cannot delete it and I'm not sure where to ask for assistance. Can you direct me to the right group or help get me off of this workspace? Thank you, Emily
-
Data Shuttle Errors (Column mapping, other?)
Hi All - We are using Data Shuttle to offload content to sharepoint for the first time, and I've made sure my headers match, etc. I've tried both CSV and EXCEL. I'm at a loss at this point, and have seen others suggest similar issues without much detail on 'resolution' - any insight is greatly appreciated. Same error, same…
-
User Report
Hello, I unshared a user from all of our sheets about a month ago using the Admin Control Center. At one point, this user had Admin access on many sheets. When I run the User Report, the user is still showing as Admin or Viewer on sheets they were unshared from. I’ve manually checked several of these sheets and confirmed…
-
Selecting the best Smartsheet for your project
I need to make sure I am selecting the correct smartsheet workspace for my project. I am trying to create a workspace to track and share client implementation. How do I add a Start date and then the sheet automatically adds task dates, as well as deadline, completion percent dates without having to add all manually. I seem…
-
How to Display Proof Images on a Dashboard
I am looking for a solution to create a workflow that automatically displays the most recent Proof version as an image on a dashboard. I have created both a report and a sheet that mines only the rows that have proofs into a stand-alone sheet/report but are not able to find a way to have Smartsheet pull the proof image to…