-
Moving rows of Cells (including attachments, comments associated with each cell)
Hello all, New at this so this question may be pretty easy for more experienced users. Does any one know how to move one cell to another while keeping the attachments, etc.? Marie
-
Nesting Formulas excluding future dates
Hallo Everyone I have a Nested Formula that looks like this. =IF((Eficiencia19) >= 0.9, "Green", IF((Eficiencia19) <= 0.7, "Red", IF((Eficiencia19) > 0.7, "Yellow"))) What it does , it automatically put a symbol, depending of the value of a cell. It does this independendly of the date. Green : >=0.90 Yellow: > 0.70 and <…
-
More sheets open that the top ribbon can show
I regularly have 10 sheets open that I'm working on at any given time need to QUICKLY switch back and forth and clicking the ... and clicking to the sheet there takes an extra couple of seconds that adds up when you do it 100 times per day. I'd like to request an enhancement to have multiple "rows" of tabs, instead of a…
-
Hyperlinks reformatted
I have found that when I import an excel sheet that has a hyperlink to one of my test procedures, it appends the link with an extra “.0”. For instance, one of my test procedures has a document number "75895", and it has a hyperlink to a website that will open document number "75895". The problem is that when I import this…
-
Cannot parse the Hyperlink function, unfriendly hyperlink import
OK, so the only way I have found to import a hyperlink is to do a lengthy workaround. When creating spreadsheets with lots of hyperlinks based off of a reference number, I use the hyperlink function to generate the links to URL by putting in the =HYPERLINK(domain,number) formula. This is way better than manually generating…
-
Ignoring empty lines and blank cells in Import feature, losing lines and format
I'm not sure if this is a known or new issue, but I just discovered it today, and it's not cool. While importing a spreadsheet that has 17 columns and 350 rows, I found that the file I imported into SmartSheet was not like the original. I identified two problems: Starting with the worst - if the first cell in a line is…
-
Assigning tasks to more than one person
I can't figure out how to assign a task to two people from the contact list. Is there a way to do this? Thanks for any input!
-
Calendar - Persistent Day
I have a Team Vacation schedule (the team is working in 4 different countries) and have also added dates for holidays which the company is also off according to the local holidays. Is there a way so that these holidays will show down the Gantt chart so that I don't have to always scroll to where the Holiday is set to see…
-
Using a template multiple times in a sheet?
Hi I need a series of 8 lines (template?) repeated within a sheet along with any discussions/attachments. These lines would be added at various times throughout the year as required. I do NOT want to use a template to create a new sheet with my required lines....just to be able to add to existing sheet. Any thoughts folks?
-
Insert row does not auto-fill
I thought this worked before, but maybe I am mistaken. When I insert a row (using the right-click menu, the row drop down, or the insert key), the formula from above and below the new row do not auto-fill. I really don't remember seeing that before. Craig