Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Conditional formatting for how overdue something is
Hi all I am trying to use conditional formatting to change the colour of the date cell for when the date cell is over a week ago, and then another color for when the date cell is over a month ago. I think I may be missing something! So in effect, the cell would be normal when under 7 days overdue, when 7 days overdue it…
Contacts: Importing fails ERROR "No .csv"
I have read the articles on this topic and have tried saving in as many formats as I possibly can. All colums are named and in order as suggested (unless I am overlooking an error) Please help, I cannot import contacts!
Primary Column
Why is the primary column text only? I would like to make this a drop down. When i move the primary column to the last column it then gives me difficulties with sub tasks. Any suggestion on how to use a droup down in the first column and also have subtask
Can I setup forms to have related child field relationships? (Example: If option A is chosen then fi
I want to have the capability to include "child of" field relationships in the form builder. This would make it easier to get granular and more relevant responses. Is this possible now? Or on the roadmap? Regards, Isaac, Quantum Corporation
Travis - Formulas in Sights
Travis, I am looking to put a simple formula, a count down formula =(Date1-TODAY()), in a Sight. I have the formula built into another sheet at this time but I have to go into that sheet everyday to get the formula to calculate and then update the Sight. Any thoughts on adding that feature to Sights?
Limiting User Editing Capability by Column
We have one column within a sheet that we'd like to 'lock down' to editing by Admin only, but users need to be able to edit other areas of the sheet, so we have to have them as Editors. Anyone know if there is a way to accomplish this? Thanks!
Cells deleting contents
When i click into a cell the contents deletes. The cells have been prepopulated by an admin user and when i want to view a cell in the line or to mark task as completed the data within the cell is removed. (This is only when i click once)
Construction template
Has anyone created a template for construction comparing %completed, %programed and %paid vs the date? to be able to graph it something like this
Mobile Numbers
Im sure this would have been asked a thousand times? But how do I stop the zero from being deleted from the begining of a mobile number?
Anyone else's sheets not filtering since May 7th release
Our reports are no longer filtering on key fields like status and priorities. We noticed it on Monday May 9th and everything was working fine May 6th. Makes our reports contain alot of past items as now not filtering out complete tasks. Anyone else seeing their report sheets not working right this week?