-
How to pull text after a multi-character "delimiter"?
Tried searching and couldn't find another discussion that matched my issue. I am attempting to write a formula to extract only what falls after the "DBA" portion of a company's name. For example if the company name is "Vance Refrigeration DBA Kool Guyz" then I just want to pull "Kool Guyz". I've tried using FIND and LEFT,…
-
VLOOKUP to another sheet using images
I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the image. This would be so useful to actually pull in the image itself as a…
-
Did they change how contact list and formulas interact?
I have a sheet that is mapping the supervisor email from a different sheet using vlookup (I want to keep this formula active in case there are supervisor changes). The format for the supervisor email is contact list. I'm using the supervisor email mapped in a countifs formula that was working last week. Now I'm getting #NO…
-
Help with setting up automation
Hi! So In the Advanced Formula Handbook, it looks like there's a formula that if implemented correctly, we can match it with an automation to notify someone that once a dependent task is completed, you can notify the assigner of the next task that it's ready to start. Has anyone had any success with doing this? "Your sheet…
-
Which formula should i use to tally up the total amount of t-shirt sizes?
Which formula should i use to tally up the total amount of t-shirt sizes? I've tried different variations of sumif and countif but i cant seem to figure it out. For example: My column name is Quantity/sizing with all of these different size quantities: XS - 4 (I want another column with a shirt sizes calculated Total:…
-
INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"
When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong. =IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(INDEX({South - Service Status}, MATCH([Ticket No]@row, {South - Service Range 1}, 0)), IFERROR(INDEX({Tamil Nadu - Status},…
-
How to compare SIMILARITY not exact match in a string of text/description/summary
I am trying to create a formula that compares a New Intake Form's description/summary to completed and Archived Intake Work Form's to see if this is a project similar to what has already been worked on in the last 5 years. I am not looking for an exact match, but something similar enough to pull the Old "Intake Request ID"…
-
Looking for a means of keeping an updated "automatic" inventory
Is there a formula I could use that would: 1.) When "Complete?" is checked on the right side… 2.) Subtract the "Units Requested" with respect to "Lot" from the left side and populate the "Remaining Inventory" The idea is to have a master inventory sheet that will show remaining inventories while having a secondary sheet…
-
How can I get this formula to return a value when two criteria are met?
Initially, I used the formula below to return the Payment Term value from my Contract & Exhibit Tracker where the vendor #s match between my source sheet and output sheet. And it worked. =IF(ISBLANK([Vendor #]@row), "No Match Found", IFERROR(INDEX({Contract & Exhibit Tracker - Payment Terms}, MATCH([Vendor #]@row,…
-
COUNTIF reference not working
I have a time entry on one sheet where times are entered in the HH:MM (24 hr) format and another column that pulls the hour of that day. [Time Received (FORM)] - time in HH:MM format [Received Hour of Day] - pulls the hour of the day with the following formula: =IFERROR(LEFT([Time Received (FORM)]@row, FIND(":", [Time…