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

A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…