-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
-
Phone support
Hi, is anyone aware if Smartsheet offers phone support in Australia when needed? regards Michelle
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Can't change task bar colors
My AA left unexpectedly and I took over her role as administrator and owner or the sheets/reports she created. Problem is I can't get the color palette to come up to change the task bar colors no matter what I try. What am I missing?
-
Smartsheet Referral Program
Hi, Wanted to check if smartsheet has any referral program (where existing user introduces new users) ? If yes, how does the same work ? Have tried checking the app but unfortunately couldnt find any such information pertaining to referrals there. However there is a Smartsheet Referral Agreement available on web thus not…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Lock Columns
Each member of my team have their own report, they all have the same columns as part of their report however, each person is in charge to update the information of only certain columns. For example, if I have 4 columns name A, B, C and D and 4 reports each of them for 4 different people that are able to see the 4 columns.…
-
Cell Linking and Circular References
I have created one parent sheet with multiple columns of information that I have copied into more limited child sheets. I've linked in all of the information in the child sheets from the parent sheet, so when the parent sheet is updated, the child sheets update with the related information. I do however want to give users…
