-
Merged: Mind Map View (WBS View)
This discussion has been merged.
-
Dropdown options limited to certain people
Hello, Quick question. So i have a drop down menu with 6 options. Is it possible to have on the form where if someone is selecting a option they, depending on who they are, can only see options 1-3? So it would only be a select group of people and the option choice may very. So person 1 can see 1-3 while person 2 can see…
-
Automation
Hallo Team smartsheet Struggling with following below you see a list Colom Picklist is a Tik box ... To prepare a list for the warehouse we need to tik the box manual. once the warehouse scanned , the sheet is proccessing a new line and when in colum action is OUT the tink box in Colom needs to be tikked automatic. But it…
-
Dashboard - Fillable Sheet
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
-
Workflow and Automation Simulator
What problem are you trying to solve? I want to solve the waste of time it takes to test automations from several conditions and actions. Furthermore, the additional accounts that need to be created is cumbersome; just for checking if everything is working properly. The solution would be as followed: Show a macro view of…
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
Formula says #INVALID OPERATION.
I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION. =SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete"))) The Priority column is a symbol column…
-
Allow multiple contacts per cell AND Restrict to list values only - Not Working
If I have a "contact" type column where I want to "allow multiple contacts" AND "restrict the list to the values" I've added to the column, then the list is not available. If I turn off the "allow multiple..." option, then it works as it should. Is there a restriction on contact type columns that disallows using both of…
-
Cell to hold multiple values
Hello, I am trying to create a formula (or if there is a better way please let me know) for a cell to have multiple values if true. So i have one column with a drop down with 10 different options and 10 more columns. If someone picks the first option then they only need to fill out 2/10 columns and if they pick the second…