-
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.