Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Comments
Is anyone as upset as I am with the changes to the comments feature? My clients are all over me because now all comments entered in a day can not be printed together, they all have to be printed individually.
How to count only Green symbols in status column
I am trying to count only the green ball symbols in my status column. I have looked around for a formula to do this and so far have some across COUNTIF(CHILDNREN) formuals. I don't have my sheet organized with children so I don't think that will work for me. I am looking for the return vaule to be a number. I have tried…
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
Web Forms
The only way that I know to add an attachment accessible to the user is to create a link. (I'm not referring to the user uploading a document to the web form.) Is there another option?
Sum rows that are not children
I am creating a SS that contains a row for each event and below children for event expenses. The top/parent row calculates the sum of the children beneath it. I would like to create a Totals row that calculates the sum of all the top/parent rows. Is this something SS does?
Need help on Summing Values based on drop down menu that contains text options
Hi, I have a question regarding using formulas and drop down menus. Similar to an FMEA, I want to have dropdown menus (High, Med, Low) for the severity, occurrance and detectibility. Then I want to have a formula that produeces a RPN (Risk Priority Number) by assigning the value 10 to High, 7 to Med and 3 to Low and…
Merging cells
Hi! Is there a way of merging cells across one row? Thanks.
Project Resource View
Project resource view. Is it possible to show all assigned tasks within a single project sheet for a single resource. Managing a master schedule with multiple tasks assigned to resources.
Sight Reports
Building sights take a lot of work and time. I think one way to reduce the amount of time required for building it would be to be able to use the report wizard when selecting the report option. Prebuilding reports and going back and forth between the sight editor seems unecessary. You should be able to build a report while…
Formula for today's date
How can I include today's date in a report or sight?