-
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!
-
How to track external dependencies
I am building a project that has external dependency to be delivered on a specific date . How do you create this dependency? Do you create a task with no duration? (start and finish date are same)?
-
Add hyperlink to related sheet from the report
I'm creating a "summary schedule" report from the project schedule and would like to include a hyperlink to the full project schedule within the report for quick access. Any tips to offer on that?
-
Removing Single Cells
Hello, I am looking to remove a single cell from a grid and have the cells underneath move up but I am only given the option to remove rows which disrupts formulas I have in place. Is this feature of removing single cells available?
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…