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.
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…
I want to set the end date, and have my project manager set the duration which will in turn change the start date. Is this possible?
Date/time stamp format on PDF export
Hi is it possible to/how can I change the format of the date/time stamp included when export to PDF? I'm not sure where it is coming from, but it would be very nice to drop the "o'clock WEST' wording that is being included by default (see attached screen shot). I am using Safari v9.1.1 on Mac OS 10.11.5 Thank you Erik
Edit Lanes in Card View
Is there a way to change the field Card View uses as its lanes? When I try to Edit the lanes, all it does it changes the name of the field in the Sheet view. For example, Card View has selected the Confirmed field (a Yes/No field) as the lanes, but I want it to use the Status column as the lanes. Any way to make that…
Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extracting…