-
Workflow not showing all dropdown options
I have a simple workflow that changes the value in some cells when "business Critical? is not set to no but for some reason not all the values in the dropdown show up the last one just isn't there and when i try and copy that last option into the workflow it just doesn't recognize it and works the same as if its not there…
-
Update same Column Cell value
I have two columns id and Name . when user enter something in column Name in any cell . all the rows having the same id name Colum should be updated to same value entered by the user Any way to do by formula or workflow user enter abc in 1st row with id 1 id Name 1 abc 1 2 3 1 2 output id Name 1 abc 1 abc 2 3 1 abc 2
-
Duration Formula Help
Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows. I…
-
Convert SOME of the blanks to zeros
I am creating a new sheet, and so far, about 30 columns. Of these columns, 12 are metrics which require a numeric value. I would like to create a Workflow to convert the blanks in ONLY these 12 columns to 0. It is likely that some of my other columns will be blanks, but I do not want them to be converted to zeros. If…
-
how to change a cell value when a new row is added
Hi I am trying to use a workflow that changes the value in a cell when a new row is added. This cell is already on a row in the sheet when the new row is added. I have hit a road block as when I set the trigger for when rows are added it does not change the value in the cell so I am guessing the workflow only runs on that…
-
workflow trigger
when a workflow is set to trigger when a new row is added, does that workflow only run in the newly added row all the whole sheet
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
-
Smartsheet Connection Issues and Workflows Missing
Good morning all, Is anyone having issues connecting to sheets and/or missing workflows? We've been having connection issues all morning, either getting message stating "Too Many Users" or Smartsheet is not working. When I finally got into one of our sheets, I noticed all our workflows are missing, we had over 10 active…
-
Formula to pair staff based on criteria
Hello Smartsheet community, An idea came up recently about pairing staff up who work in different divisions for a random coffee chat to increase staff engagement. We could use Smartsheet to create a form to gather info on staff who are interested in participating and what division they belong in but is there a formula I…
-
Ran workflow - sheet remains blank, data not pulled from most recent attachment
I am trying to create a workflow that will merge data/adds rows when a new file is attached but every time I run the workflow, the sheet remains blank. After I attached the file, I deleted the data to ensure the workflow was working properly. See the steps I followed below. I have tried both options listed for 'source…
