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 2016 Posts
Archives for April 2016
Discussion List
Automatic Move
One of the ways I use smart sheet is to manage my work load. Once a project is completed, I move it to a completed row to keep record of it. Is there a way to automaticaly move a row once the staus has been change to "completed"?
Smartsheet App for Outlook desktop installation
Is there an installation available for the Smartsheet App for Outlook 2013 desktop? Basically looking for an .exe or .msi that can be used to install the add-in for Outlook. The installation from the Microsoft App Store doesn't work for my account. I have a corporate Office 365 account and my email address matches the one…
Enhancement Request: Open new Report for editing
is there a reason that when I create a new Report (using the Create New button/menu) that the Report does not immediately open for editing? (I can't think of one) Craig
Calculate with row numbers / Formulas not copied after adding new rows
Every now and then I notice that formulas are not copied when a new row is added to a sheet. Very often these formulas are placed in hidden columns and so it's not immediately obvious. So, I'm looking for a way to get an "alert" in a cell within Smartsheet whenever a cell in a specific range is empty, showing the amount of…
Reverse COUNTIF / COUNTIFS
I have a list of 200 items. I want to count the ones that are NOT "Jimmy" =COUNT([columnA]:[columnA] - COUNTIF([columnA]:[columnA],"Jimmy") But I have a second column that I need to know the NOT "Jimmy". what I would like is COUNTIFS( not this::: ([columnA]:[columnA],"Jimmy"), and this ([columnB]:[columnB],"Maryland") )…
Merging two sheets into one.
Does anyone know how to merge two sheets into one seamlessly to include all attachments and discussions please? Thanks in advance, Andy
Resource Allocation
Good Morning, 4/28/16 - OK, so I just started a new sheet and everything is working fine now... QUESTION is could my sheets become corupt somehow. This is the 3rd time I've had to re-creat a sheet to make things work again. When I am looking at my Resource Allocation it is showing I have myself over allocated on 2 days.…
Data / Row viewing options
Ideally I would like to be able to have both my customers and my suppliers looking at one sheet - and be able to select what each 'collaborator' on the sheet can see! so the customer can't see the rows applicable to the supllier and vice versa - which would save so much time being able to run a project from both sides on…
Formula to hold a boolean value if a row contains an attachment or not
Hi, How can I put in a formula to assign TRUE if the row has an attachment, and FALSE if the row does not have an attachment? Thanks
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.