-
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…
-
Chart data ranges
I am creating a dashboard with two separate charts. I want to compare the data between the two charts but the data ranges for each chart is different. One goes from 120 to 200 and the other goes from 100 to 500. Is there a way to set what the data ranges for the charts?
-
I'm looking to hyperlink words in a dashboard to a cell in a sheet?
Hi, I built out a dashboard with text boxes and need to link a specific word in the text box to a specific cell in a sheet. Is there a way to do this? I know that you can link cell to cell from sheet to sheet or can link to a sheet from the dashboard, but I cannot figure out how to link to a cell from a dashboard. Thank…
-
TIME OUT ON SAVE!
I am trying to insert rows in a formula-laden Smartsheet file ~2500 rows and the file will NOT save and keeps timing out. Whether wifi, ethernet, in the office, vpn......no solution Any thoughts on how to resolve?
-
Roll up Sheets
I have multiple sheets from different workspaces that need to be rolled into one sheet. What would be the best way for doing this?