Good afternoon Smartsheeters ;)

I am only new to Smartsheet and have started working on some existing docs.

We have a very clunky and manual way of applying a designated PRIORITY number.  When the sheet for each project/group of projects is first started, its easy - everything is labelled from



We are starting to use Smartsheet heavily in a lot of our processes.  We deal with contractors on a daily basis.

We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with.  They may not directly interact with other


Good Morning,

I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns:

Job Type

Planned Start

JSH *job site hours*

What I need is to calculate the sum of total


Hello all,

Is there a way to do the following:

=if value in Column A, return hyperlink to Column B

This is not a website hyperlink, this is a hyperlink to a smartsheet item. I have tried pulling hyperlinks through VLOOKUPs, nested if statements in the same sheet, etc. Manually clicking through and



Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.


Trying to sort, then by, then by.  Anybody find a work around, second and third sorts pushing tasks to the very bottom of first sort.  When the first sort has exhausted all available data I would like items that meet second sort criteria to start in, not be pushed to the very end first sort.