Trending in Smartsheet Basics
-
Building a Dashboard from external survey
I'm having trouble organizing either a report or a sheet for it to be data that can be read by the widgets in a dashboard. To recap: I sent out a survey to students who had the choice of attending 3 schools. The first question asks which school they attended, then all the following questions apply to each school. I want…
-
Access Request for Smartsheet
When a user requests access to a sheet (or workspace), is it possible to REQUIRE them to provide a reason they want/need access? We receive requests from some users we do not even know. While there are new hires that would need access having the ability to have them define their reason would be preferred. And if so, how do…
-
Autofill
I have one column that has a dropdown of customer names. I want the "Address" cell to autofill with the address that was picked in the previous cell. I tried to do an automation but it seems to change the whole Address column instead of the cell. I have done an IF statement but it is only limited to 2 options... IF X, then…