- Why isn't the email address pulling via formula from another sheet for "contact"?
I created a Form for operations to fill out when they determine a ship date needs to push out. Since they don't always know who the Project Manager is, I have this information going into a sheet where the project number pulls the PM info from a master project list using the COLLECT formula. But when I try to create the…
- "Alert someone" automation not working when "links to specific fields" is selected.
I have an automation that was working before: triggered by a change in a category field. Sending update request to email address in "contact email" column. Including "Attachment" and "Comment" fields. This step suddenly stopped sending update requests. If I exclude the fields by selecting "Message only" option, the…
- Form Automation
Hi Community, I've created a form where users can submit information for equipment out of service, which is working quite well. However, a request was made to create another form allowing users to input information when equipment is placed back in service. Is there a way to create a separate form that will allow users to…
- Combining Form Submission Data with Already Existing Row Data
Hello All, I'm looking for a way to combine form submission data with data that already exists in a row. For example my row has the item information for something we're trying to resell. The form goes out to the resell companies for them to make an offer. If an offer is made its populate on a separate row. Would love to…
- 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…
- Smartsheet and Business Central integration
Hello All, I'm trying to integrate the Business Central projects table with the Smartsheet. I want to create a new project sheet in Smartsheet whenever a new project is added to the Business Central. However, it seems the Create a sheet option is not currently available with the PowerAutomate. Did anyone face the same…
- 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
嗨!我再与另一个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…
