-
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.
-
Countif formula for multiple items in parent row
Here is my table: In the Gender ID column I'd like to see a count of M and F in both the 1st and 2nd hierarchy rows. For example, in first row, K, it should end with M-2 and F-0 and the same in the 2nd row, Frizzle. For the row, 4, it should return M-3 and F-3, but under row, Dumbledore showing M-2, F-1 and Yoda M-1, F-2.…
-
Allow free users to edit a filtered sheet or report
How can I share a filtered sheet, or a report, with a free user and have them be able to edit it as well? So far all I have found is the ability to make a filtered report and then share that, however I need to share the source sheet as well then, thus defeating the purpose of the filtered report, since I only want this…
-
Resource view duplicates?
Each project I am assigned to shows twice in y resource view. Its the same for everyone. When I go to the sheet thee is only one. I deleted myself which removed a duplicate but the same sheet where I deleted myself shows me still there (the one left)? This was not happening before, only noticed today. Any ideas?
-
Submit Bottom on Sheet
Hello, I'm trying to figure out a way to give indications to doctors to save the sheet before they exit. The intake sheet can't be a form, as I have images and over 100+ lines. I'm thinking of a visual cell with clickable formula may be. I'm open to suggestions. Thanks,
-
Changing ownership makes Chart Widgets turn to Missing Source
As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team. When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing". Smartsheet's Help Desk provided this response: "... you may need to transfer…
-
Automation - Copy row to current sheet
I have a user-oriented form associated with a sheet. The sheet works as it should, but we have a specific workflow in our business where a user may need to immediately enter a nearly-identical form immediately after submitting the first form. The form has dozens of fields and the second submission is identical in all but…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
