-
Reference Sheet name in a Formula within a Sheet
I've seen a similar request for referencing the parent Workspace (though I didn't see an answer) but I am interested in referencing the name of the actual Sheet in a cell within that sheet. I am planning on auto-filling some of the task names within a sheet with a name from the first task row (this would be the overall…
-
Hyperlinking
How do I hyperlink to a cell on the same sheet? I would like to click on a cell and be taken to another page in the same sheet.
-
Anonymise form submission
Hi, I have a form which fills a sheet with an "Anonymise" checkbox column and a "Submitter" text box column. (staff feedback form) I'm trying to give form submitters the option to anonymise their submissions. At the moment, an individual has their own link which will auto-populate the submitter on the form but want to be…
-
We Need Custom Views - Sheet Level
I have seen similar requests in the community discussions, but they all seem to have very detailed needs, and would require a very tailored solution. I believe a lot of users, in general, would benefit GREATLY with a simple "custom view" option on the sheet level. Nothing special, just a simple way to view and save…
-
Best Way to Have a Back-and-Forth with Non-Users?
I have a sheet with info for a few hundred people. For privacy reasons I cannot share it with them, because they cannot view other people's rows (a selectively hidden feature I've put in a vote for). So I send everyone their information in an update request and ask them to fill it out. I then see their answer, respond, and…
-
Using Smartsheet with a Windows 10 touch screen PC
Is there any way duplicate the capability of some Windows 10 apps to rapidly scroll through data? I have a sheet with about 250 rows and it can take 3 or 4 seconds to scroll down the sheet. Four seconds doesn't sound like much, but if you are demonstrating something in a meeting, it feels like a very long time.
-
Alerts & Actions not working
I have set up several alerts, some are working, some are not. is there any reason why one alert would work and another not? can i attach my smartsheet for you to look at?
-
Plotting a total over time
I'm trying to do some rough and ready resource planning. I've created a column called 'Dummy resource' and I'm putting in it the number of people who will be working on the each task. I'd like to produce a plot of the daily total of this number (sum of people working on active tasks) against the date for the duration of…
-
Countif/Countifs Date Range
I am trying to count a certain criterion that occurred within a specific date range and I can't seem to get the formula right. =COUNTIF([Training Date]:[Training Date], AND(@cell >= DATE(2017, 6, 1), @cell < DATE(2018, 5, 31)), Role "Clinical") I am trying to count, for example, how many clinical staff were trained between…
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
