-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
Allow Unlicensed Users to Hide Columns
Is it possible to allow unlicensed users with certain permissions the ability to Hide a column.
-
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…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
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?
-
Managing Cross Sheet References at the Workspace Level
Today, cross sheet references must be managed within an individual sheet. I'd like to be able to implement and manage cross sheet references at the workspace level as well. Use Case: 3 sheets containing unique data, but identical columns that are fully replaced weekly; 2 reports generated from those 3 sheets. The 2 reports…
-
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…