-
Bring in data from multiple sheets
Hi, I'm fairly new to Smartsheet so apologies if this is obvious. I am essentially trying to bring information from 2 sheets which I can then edit or work on. Some background.. We have a sheet which details resourcing for ongoing projects (backlog) and another which contains information on the pipeline. The backlog gives…
-
Conditional Formatting Bug
I set up my conditional formatting to colour code my "type" column as a visual reminder on my action. It worked for many weeks but now when I insert a row and use the "type" column to select a type from the drop down menu, it formats that cell as white background and white writing (showing nothing selected). My conditional…
-
Speed issue
A colleague using a sheet with approx. 250 rows is finding it functions extremely slow. Takes a couple of seconds to respond to movement of the mouse or scrolling. The same sheet is fast for me and other team members. Any ideas what the issue might be? His browser isn't generally slow.
-
Disable "Start a Hangout" pop-up
Is there any way to disable the "start a hangout" pop up from appearing every time I accidentally mouse over a contact cell? It's driving me nuts!
-
Dynamically assign view permission
Hi I have a contacts column in my Sheet and would like to dynamically share the sheet with these contacts. Each row has an owner that frequently changes. I'd like to be able to "just" change the contact in the row and with that he gets or losses access to the sheet and its reports. Is there a solution for that? Thanks
-
Creating Master sheet
Dear All, I am currently looking at three different projects. I need to create a master sheet with the module, WBS and the Deliverables from each of these projects into one master project sheet. I tried the Report feature but it did not work. Can I please request you to send me some suggestions on how the same can be done.…
-
Attachments oddity
Good afternoon, In looking for a particular attachment, my result took me to the "Attachments" tab on my sheet. However, that attachment is not on any row in my sheet (I physically checked each of the 300+ rows in that sheet to verify). Curious why that tab shows far more attachments than what are actually attached to…
-
if with blank cell, RYG ball how to become Yellow.
Hi, As per below formula, if with blank cell, How can i add the formula for RYG ball auto change to Yellow. =IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red")) Thanks in advance.
-
Multiple Column Summaries
Hello SS Community, I am trying to create a summary of data from 2 different columns. The first column is "Industry Type" (there are 7 different types). The second column is the amount of ($'s) for that industry and client. EX: Client 1 - Industry type "Distribution", $5,000. Client 2 - Industry type "Other", $3,000. This…
-
Lines disappearing from smart sheet
hello everyone, I’m wondering if anyone els is having this issue that I’ve been having for a while. My team and I have noticed that we are loosing lines of data without anyone from the team deleting it. I was scepticke at first when an employee told me that, but came to elizecthat it is true when it happened to me a few…
