-
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
-
Automatically creating a new sheet
We have a form where new employee data is entered, which auto-populates a dashboard smartsheet. What I'd like to do is have a new smartsheet using the data from the new row in the dashboard to create a sheet (from an existing onboarding checklist template) for the new employee to track their progress. Does anyone know how…