-
Enter Form information on existing row
It would be amazing if Smartsheet could allow for form information to update existing rows on a sheet. An example use case is quality control, we want the task worker to fill out fields related to a task he is working on a project. The worker is in the field and sifting through dynamic view or project reports is not a…
-
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?
-
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…
-
updating predecessor automatically
Hi, if I add a new row above an existing row which has a predecessor, does Smartsheet automatically update the predecessor number ?
-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Expand and collapse ALL on the mobile app
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
-
How to visualize the same timestamp that I see in the grid(sheet) and in dynamics view?
I created a dynamics view but the problems it's that the timestamp that I visualize its a different. I already reviewed the timezone an its set similar in my computer also I review the time format and its the same. Any solution or suggestion?