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.
Archived 2017 Posts
Archives for March 2017
Discussion List
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
Alert Owner When New Action Is Assigned
Trying to figure ouut how to alert the Owner when he/she is assigned a new Action Item on the SmartSheet. (Owner is a column linked to users). Want to avoid everyone (45+ users) getting an alert everytime an owner get a new assignment -- just the specific owner. Thanks!
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
Sight Cell Linking
I want everything that is under a Parent Row on a Sheet to show on our Dashboard. Is it possible to cell link ALL children under a parent row to a Sight/Dashboard? Examples: If any rows are added they will be included If only one row is populated, only one row will show in Sights
Deleting update requests
I have a sheet for meeting action points and use update requests to keep on top of oustanding actions and mark and action complete when it is done. I have been trying to delete update requests on completed action s but have found you can on some and can't on others (the delete drop down is greyed out). There appears to be…
Totaling a column with check boxes
I couldn't find an answer that solved my problem so am asking this question. I am trying to sum up a column where some of the fields are checked and some are not. Can you please help me? I have tried looking at the SUMIF calculations and keep getting the #BOOLEAN EXPECTED error. Thanks in advance. Linda
Consolidate time sheets
Hi relative newbie here... looking for help. I would like to set up time sheets for individual team members is a design studio. They will list jobs worked on by job number to allocate time worked on daily. I would then like to consolidate all the data into one master sheet and run a SUM IF formula to calculate the total…
Screen Snipping Tool
Is there any way to screen snip and have the snapshot saved as an attachment? The only way currently appears to be screen snipping and save into word and then attach or save as image and then attach that
Exporting Contact Emails in Sheet to Excel
We have a contact column in our sheet with names and email addresses. I would like to export that information into excel but it will only export the names. Is there a way to get the email addresses?