-
How can I create drop downs with selections based on a previous column?
For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise. For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc.…
-
Smartsheet connections with count
Good afternoon, I am trying to see if it is possible to connect 2 smartsheets and have one supply the results from the team working the data. IE: Business Partner submits request for an area with a unique area ID to be reviewed via a form. Our team then uses the form and goes order by order to review and validate the…
-
Barcode Scanner not showing Barcode Picture
I am trying to update our inventory system to Smartsheets and I want to take a picture of a Barcode and instead of geting the picture of the Bar Code I am getting just the numbers. How can I go about fixing this?
-
Column Limits vs Data on a Single Row
TLDNR (short version) GOAL – everything in reports / sheets to be on one row per project PROBLEM – I run out of columns and reports won’t merge data from multiple sheets to one row. (long version) Typical spreadsheets can present as one project row and all it’s details in columns to the right (scrolling is left to right)…
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
Report Sorting Assigned To Column
Hi, I had posted another discussion about an issue, but I think I have another issue that might fix my previous issue if I can resolve this current issue. I was having trouble with manipulating tasks and having a view of all resources to be able to manipulate tasks. Here is that post:…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Mandatory or Required fields to complete in a smartsheet
I have a need for users when updating or entering data in a cell in a smartsheet that they must complete some mandatory fields. A webform has this function, however on existing rows it would be ideal to have users who are given updates or entering in a new row to have to complete some mandatory fields before final saving…
-
Copy and pasting from other sources - why is it so annoying
Example I am trying to add a new 'row' via card view, in the pop up edit form that appears, I then go to paste in some key data, such as an email address from an email, the person's name from an email. When I click click, the cells are empty, if i add a space after the pasted content, its ok. What gives?!
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel