Formula value

Hi,

I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date.

When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information.

I currently use the Paste special but this can not be automated.

Thanks

Find more posts tagged with

Construction

Formulas

Comments

Andrée Starå

Hi,

Not sure I follow!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

ydionne

Hi Andrée

here a print screen of my current work sheet.

The main document, "sales order", is a task list that refers to 2 other documents. One of the documents, "product condition", consists of typical time data to achieve different product. The second document, "import", is used to import information about active orders with their respective delivery date from an SQL database.

When receiving the sales order to be produced, the number is entered in the main "sales order" document. It imports the delivery date via the "import" file. A retro-dating is done using the "product condition" document to determine the start date and the end date so that the delivery date is respected.

The problem is with the document "import". When an order is completed, the delivery date information is no longer entered in the "import" document. So in the main document empty boxes appear.

Smartsheet shoot.png

Andrée Starå

Ok.

The third-party service, Zapier could be an excellent option for this scenario. Is that an option for you? Another option could be the Smartsheet API.

Would any of those options work?

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…