-
Anyone else having problems getting into SmartSheet at the moment?
I have been looking at a "loading" gif for the last hour. Multiple refresh attempts and colleagues experiencing the same. All other internet based sites working fine.
-
Calendar view from multiple sheets
HI I am new to Smartsheet and I basically want to use Smartsheet to create a schedule for my business and life to be seen in a calendar and Gantt view. Before creating my sheet/s I am in a dilemma if to create a different sheet for about the seven different projects constituting my business, or to create one sheet. The…
-
Dynamic hyperlink from cell to external URL stopped working
Hi guys, I have been successfully using a formula to enter a hyperlink in a cell, using, for example, syntax like this: ="http://ServerName/Default?queryStringParameter=" + [Column Name]rownum This approach enables you to use the [Column Name]rownum syntax to dynamically create the URL based on the contents of other cells.…
-
Calendar View Descriptions
Is there a way to display anything other columns rather than the Primary Column for a sheet in the Calendar view? I have reports that display specific tasks for many resources which I would like to run in a calendar format. This would be ideal for me if I could choose which column to display for the task such as the…
-
Row Height
Is there a way to shrink row height, even if the font size does not want to allow? This is possible in MS Excel, even if lower parts of letters (like y, g, etc) are slightly cut off.
-
Sheet Roll-Up
I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.
-
Way to format column number to sort by number then letter?
Hi, Hopefully a very basic question - how do I format a column so that a number with a letter added will sort after the original number. So similar to how a "16.5" would come after a "16", I want a "16A" to come after a "16". Currently when sorted it is being thrown to the end of my numbering system (see below). Any help…
-
How can I allocate part-time resources to tasks
I have a number of resources that work a specific number of hours a week but on a flexible basis and want smartsheet to be able to recognize that % allocation based on the number of hours that the resource is available? Is there a way that I can record the number of hours that a resource is available and ensure that I am…
-
COUNTIF where cell contains checkmark EXAMPLE
Need a 'countif' example, where cell contains a checkmark?
-
sorting by row ID
Dear Smartsheet users Community members, can someone answer to my pretty basic question. i have a challenge to sort the table back to initial order per Row ID (1,2,3,4,5,6,7....) after sorting based on some other column info (e.g. date, amount etc). after obtaining certain info based on sorting of different collumns, i…