-
Search function not always working on iOS
Hi everyone, I created some new spreadsheets today, and while I'm able to use the search function fine on the computer, when I search the same thing on the mobile app I get no results. I'm still able to search many other sheets on mobile, but not the new ones that I created in the last hour. Is there a fix for this?…
-
Jira Integration - follow Row across sheets
I have a workflow for my team that uses 3 sheets. All requests come into the 'Intake' sheet using the Smartsheet form. Once approved, those rows are moved to the 'in progress' sheet. Once completed, those rows are moved to the 'completed' sheet. I have certain requests that require I engage a separate team which works out…
-
Cell reference - when original cell content is deleted, the referencing cell still shows value
I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find. What does not work is if I later on decide to delete a…
-
Split a list into columns?
Hi, I have a list in a column which is separated by commas. I need each number in the column to be split into it's on column. Is there a way to do this? Thank you
-
Can one form link to two sheets?
Hi, I created one form but can the data be linked to two different sheets? Thanks.
-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
-
WBS Formula Question
I was hoping to get some help with a question regarding the WBS template from SmartSheet I found this template very helpful, and I would like to use it for my projects, but I need a little assistance with modifying the formula. I am not sure if this same setup can be used when the project tasks don't start on the first…
-
Filter on card view when using forms
I'm setting up a form for people to submit requests to my team - it's a large form with a lot of logic input into it and there are 20 different categories that people can choose from when submitting a request. I want my team to be able to easily see the jobs that come through as in grid view it shows all columns (even…
-
Use Formula to Assign Dropdown Selection in Column
I would like to have the column titled Alert Level return a symbol from the dropdown menu based on the number of selections in the Alert column. I'd like the symbol to be green if there the Alert column for that row is blank. Blue if there is 1 item in the Alert column, Yellow is 2 items and Red if there are 3 or more. Is…
-
How do I pull in a table into a Dashboard?
I linked a form to a sheet that has the data that I want to pull into a dashboard. How do I create a table from that data into a Dashboard and be able to format it as needed.