Sign in to join the conversation:
I'm trying to create a workflow and for the Trigger Field I've got a cell that contains more then 5 options but the workflow is only showing the first 5 options is there a way to get the rest of the options to show?
Hi Kathryn,
That sounds weird!
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I've attached a screenshot of the workflow as well as the list of values for the column. It seems as if the issue is being caused by the length of each line. As you'll see in the workflow is easily shows items with just the category and no description. Are you aware of any limitation on number of characters?
Isn't it possible to scroll down?
Can you try to add empty rows between the selections?
Any change?
Andrée
I tried adding a space between line with no change. The workflow list won't scroll past where I have it and there are items missing. If I remove the descriptions all of the items will show up in the workflow list. I'm pretty confident this is due to some character limitation.
I've never heard of a character limitation in Dropdown lists. You can have up to 5000 options.
How many characters do you have? There is a limitation in cells at 4000 characters.
I'd be happy to take a look and see if I can notice anything!
Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Andrée
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
