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 p…
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Un…
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled…
Good Day All, I am wondering if there is a way to apply this format to my sheet. I want to be able to move a task to the executive dashboard automatically/ real time. For example, I want to be able to…
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem…
I have an MS Access databases set up with the Data Connector. I can link to my spreadsheet and read it, but cannot edit nor append to it. Normally, when linking via odbc to an external data source, MS…
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 base…
I've been searching the Community section but am having a hard time finding the exact answer I'm looking for, so I hope someone can help. I haven't worked with Reports or Dashboards before, so I'm jus…
I'm trying to create a formula that will look at my "Measurement" column for the text "PBI" at the beginning of this formula: =IF([Rank/Actual PTR]434 > [Score/Goal PTR]434, "PTR Exceeded", IF([Rank/A…
I'm new to Smartsheet. I'm trying to source a report to my Dashboard but it is only allowing me to select reports where I'm the Admin, but I'm the Owner. How can I go about adding reports that I'm the…