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 January 2016
Discussion List
I need to build a formula that looks at some cells in a column but not all of them.
Hi everyone, I'm trying build a formula that looks at a column of check boxes, and if certain boxes are checked off, it will give me a "green light". Here is the formula that currently works: =IF(COUNTIF(Completed13:Completed26, 0) > 0.5, "Red", "Green") It compiles all the check boxes in my column from row 13 to 26,…
Changing the Fiscal Week from January to July (or any other month) does not affect the Timeline week
I am trying to view my Sheet in Gantt view, tracking top row by month and second row by week. This works fine, except my company's fiscal weeks are offset. I changed the settings modifying start of fiscal week to July, but the view on the Gantt didn't change. Same result using any of the other available months as start of…
Reducing clicks with Highlight Changes
Here's a suggestion for how Smartsheet could reduce clicks for the Highlight Changes feature. I personally love this feature in general, but I often just want to toggle it on and off again. So I thought it might be useful if the button were bifurcated into two separate functions: -Toggle Hightlight Changese on/off -Adjust…
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
Add image via web form?
I want to create a team directory using the new feature where you can insert an image into a grid layout. However, instead of me gathering everything and uploading it myself, I want to send the team a link to a web form and have them put in their own image and info. Is this possible?
Google Docs attachment Error 401
I want to attach documents through Google Docs so when I make changes to the original file, the attachment in SmartSheet automatically retains the corrected version (which it does not if you upload a file from your computer). However, when I select Attach, Google Drive, I keep getting the following message: Unauthorized -…
Deleted lines don't go away
I've deleted lines but they are still showing. What I mean by this is I've deleted lines but the sheet is still showing there are indented lines there. Anyone else have this issue? There is no content below this.
Lines disappearing
Is anyone having an issue where lines will mysteriously disappear? I was working on a sheet, went away to another application and when I came back 95 lines were missing. I was lucky and didn't lose too much work as I had just started on the sheet but it could have been worse. I couldn't undo it because I just realised I…
Combining Text and Formula Into Same Cell
Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function). The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]". I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a…
Key Command to Toggle/Cycle Through Open Sheets
Is this a thing or a plus one on a wish list? Much like toggling through open browser windows and all other apps etc I would like to be able to command tab through my open sheets. This might be a bit of a princess request but worth a shot.