-
Automatic Notification in Form Entry
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…
-
Cell view history
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
-
Merged: Specific column with cell history
This discussion has been merged.
-
How to add multiple costs from dropdown menu items
Hello, I am struggling to identify a formula that can read multiple selections in a drop down column, find the corresponding selections and prices on another sheet, and return a total cost. The sheet supports samples that are analytically tested. The user chooses which tests they want to conduct for each sample on the…
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Mirror Row
I have a list of employees on one sheet. Can I have that column mirrored to another sheet so changes are made in real time and I don't have to update two sheets?
-
Merged: Enter Form information on existing row
This discussion has been merged.
-
Idea funnel
Hi all, I'm at a manufacturing company. I am looking into a Smartsheet solution for idea generation and management. These could be cost improvements or reach into new product development. We would likely have project goals (improve margin, expand sales, ect), ideas (that need to link to SKU's and goals) and gather input on…
-
Filter per user
I already submitted the request several years ago, but we would like to have a sheet with filters that are available only to certain users. For example: the “Bryan” filter would display only the rows containing the “Bryan” department, and only he would be able to access that filter. Another filter could be available to two…