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.
Importing Text Excel Data as Drop List
Hi all - I imported data from a spreadsheet, and some data columns that had been text in Excel became drop lists in Smartsheet. So, for example, I had a column 'Frequency' which had 6 different values such as 'Calendar Annual', and Smartsheet created a drop list with those values. But other columns, such as 'Benchmark'…
We need Two Cells to Trigger a final cell location
We need When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check. I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0) ...but this is not working for me. Any help with this would be greatly appreciated!
Add text in addition to primary?
Hi - I'm using SS to track some dates for several projects. My gantt and calendar show the text from the primary column which I want. But I don't see a way to add the project name to the calendar or gantt. Can I? Thanks
Transferring information from one sheet to another when checkbox checked
I have a system whereby people are able to report issues by completing a form through smartsheet. Once the issues are clarified or resolved, I want to release certain information to other parties, but not all of it. I would like to be able to check a checkbox that says "release" and this will then trigger a transfer of…
How to highlight a date in a column based off of another date
Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. Is this possible or is is…
Automatic Address Finder
Does anyone know if smartsheet has a feature whereby the address can be located automatically by filling in the postcode on a UK Address similar to https://www.parcelforce.com/postcode-finder It would be great if someone knows an app that can be integrated into the platform/worksheet to allow for me to select the correct…
Filter by comma separated list
Product Enhancement Request Need the ability to select a range of values in a column by entering a comma separated list. The current functionality of ticking checkboxes is not viable for large filters.
Select All Option in My Contacts
Why doesn't Smartsheet have a Select All option when selecting Contacts as shown in screenshot attached. This seems like a simple thing that would save a ton of time!
Lanes in card view disappearing
Hi, I have a 'due date' column with a dropdown list. In card view the 'view by' lanes in keep disappearing after saving, the 'drop down list' reverts back to 'date'. How can stop this happening?
update request and approval request
Hi there, 1st: Is it possible to set a reminder if someone didn't update after he got an update request? 2nd: Is it possible to set a cell value with the date when a approval request is replied. Many Thanks Peter