-
How to import data from other sheets?
Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc. I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is: Item Sheet: select SKU-001 Sheet references…
-
Automation on self-updating cells
Hello everybody, I need to set an automatism based on a cell that is updated from a link to another sheet. The automatism is set to recognize whenever the value of that cell changes. The problem is: seems that since the modification of the cell is not done manually but it is modified by recovering the data from another…
-
Child Cell Formatting
I would like for child cells to automatically appear for each new row, and then have an index/match formula be able to populate a column in the parent row from those child rows. For example: New air freight request- 5 child rows with default values of the 5 carriers pop up (can't do a dropdown, I need to track the 5…
-
Recording comments in Approval Workflow
I have a very simple workflow, in which an approval is needed. While I have managed to add "a Comment" that shows up as a comment in the Smartsheet sheet, I actually want to send that comment back to the original requestor and also store it in a cell of its own. Is this possible?
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.
-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
How to auto send an Excel spreadsheet only when sheet changes are made?
We have set up automated workflows for a Smartsheet and its associated sign-up form that we've created. Current state: We have a team who receives an hourly notification from the sign-up form if there are any changes to the form. The email contains a link. What we want: The team prefers to receive an exported Excel…
-
If statement in parent row to delete children row?
I am working on a sheet where a task is to validate a set of data. If the data fails there is a follow up task to revise, if it passes the next task is to launch. Right now I have these all set as rows. But I wanted to see if there was a way to insert a checkbox for pass/fail and then based on whether that pass or fail…
-
Link automation between sheets
Hi Everyone! I'm Kaique and I have a question about Automations. We have some smartsheets on our team and we need the automation of a smartsheet to register an event (status checkbox) on another sheet. Does anyone know if this is possible? Thank you very much in advance! Regards from Brazil! Kaique Avelar
