-
Third party person using our company Smartsheet leaves the company will they still be able to login
We share our sheets with outside company people to collaborate. If this company person leaves the company, will they still be able to login to Smartsheet and access our sheets? The sharing is done by sheets and User is Not added in User Management. Please clarify! Thank you!
-
Assigning tasks through forms
Hi, I want to create a form that limits the selection to unassigned tasks from a master task list. The task columns is currently the primary column, so there is no limitation to create a drop down menu in the form. Is there a way to limit the options in a form with a filter? Thanks!
-
Missing workspace
When leaving Friday afternoon all of our sheets and our workspace was working fine. Came in this morning to find all of our sheets / work space totally gone.
-
Doing things first time right with data validation
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "text…
-
Welcome screen URL - using Smartsheet dashboard in Publish
For URL for Welcome screen content, I created 'Rich Text content' and selected option - 'Require User to click 'Accept' in Account Settings. URL is to a Smartsheet Dashboard and I published it, but when I log back into Smartsheet, unless I am the owner - I don't see the Dashboard message, upon login. As I understand, when…
-
Bug: Formula not accurate for Viewer Only
Didn't see an official bug report page, so I hope it's OK here. I've built a formula for a parent row to count orbs in children rows and display red > yellow > green, so if at least one red, the parent shows red, if at least one yellow, parent shows yellow. =IF(COUNTIF(CHILDREN(Progress@row), "Red") > 0, "Red",…
-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
How to select a last added value from a column
Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made. What I want is a formula that updates automatically as I populate new rows. Below is a…
-
How to take "canceled" out of the equation
Hello! I am trying to make it so an exclamation point appears if something is past due and not complete. Here is my current formula: =IF(AND(NOT(Status7 = "Complete"), TODAY() > [End Date]7), "High") This is working great but it will have an exclamation point appear if something is past due and canceled. I would like for…
-
Date rollback
Hi All I'm having difficulty with my date formula's. i have a few in a sheet that i'm using to display today's date and a range of important dates as well as auto adding figures =SUMIF({Tokoroa orders}, TODAY(0), ({Tokoroa Orders out Range 1})) and =TODAY() my issue is that unless i manually go into the formula page all…
