-
Cell-level Comments
Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads "Cell" next to the "Row," "Sheet," and "All" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…
-
Microsoft Dynamics D365 Finance and Operations
There is only a connector for Microsoft Dynamics D365 but our company uses the Finance and Operations Dashboard for Microsoft D365. It will only pull information from CRM and there's no connector for the Finance and Operations information that we track. We have to manually enter that data currently because the connector…
-
What happened to Default View?
Hello, I'm no longer seeing the default view option in my sheets. For example, we have a shared PMO Calendar that was previously set to "Calendar View." When I accessed it recently, I noticed that the default filter option is no longer available. Has this functionality been removed? We recently moved to Enterprise, but I'm…
-
Dynamic View does not allow anyone to change and save specific column
I have a column with a dropdown list. The column is restricted to listed values, and you can select more than one. There is no logic assigned to that column in the dynamic view, and is not listed as required. I've tried disabling the conditional logic on the sheet, and it did not correct the issue. This is happening to…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
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