eric.oEmployee

Comments

  • Hello, Based on the description of the questions provided you may be able to achieve these desired goals by combining some Smartsheet Functions. I've answered your questions in the order provided below. 1. To get the "most common piece" to show up based on the value from the "Shape Size" column you may be able to achieve…
    inFormulas For Metrics Comment byeric.o 03/01/19
  • Hello, I agree, a screenshot would be best to further investigate this situation. As a quick check, you may want to confirm the spelling is correct for the desired max cell in relation to the cell being source. It may be there is a character off causing it to not be recognized as an option for the MAX. I would also suggest…
    inHelp with INDEX MATCH COLLECT formula Comment byeric.o 02/27/19
  • Hi Paul, Utilizing VLOOKUP you could very quickly and easily reference an entire row utilizing, for example, an Order # or product ID. You are correct, you would need this # or ID to be the reference for the VLOOKUP's to function. However, once the formulas are established the Order # would Auto-Fill the entire sheet. This…
    inNo Array formulas but need work around Comment byeric.o 02/26/19
  • Hello, You may be able to achieve the desired goal of pulling row data from one sheet to another, based on specific criteria, utilizing a combination of an INDEX(MATCH or a VLOOKUP. These are further outlined here: ▸ INDEX: https://help.smartsheet.com/function/index ▸ MATCH: https://help.smartsheet.com/function/match ▸…
    inNo Array formulas but need work around Comment byeric.o 02/26/19
  • Hello, That is correct, a Report may be best for this desired goal. https://help.smartsheet.com/articles/522214-creating-reports However, if you desire to utilize a formula you may be able to achieve this utilizing a VLOOKUP. https://help.smartsheet.com/function/vlookup You may also be able to achieve this utilizing…
    inCross sheet formula help Comment byeric.o 02/26/19
  • Hello, Happy to help! If you're receiving an #INVALID DATA TYPE with your =WORKDAY(TODAY(),[Column A]1) it's likely because the =AVG being referenced is producing a partial number for example 2.5 days. To correct the WORKDAY formula I recommending do two things. 1. Adding an IFERROR will ensure that if an error is…
    inTurn average working days to projected date using WORKDAY() Comment byeric.o 02/19/19
  • Hello, Currently, we don’t have a method to calculate time but this will be considered as a possibility for future development. You may be able to utilize a Modified Date to see the difference in time when the row is altered but there currently isn't a method to subtract these values from each other. This Help Center…
    inTime Since New Comment byeric.o 02/19/19
  • Hello, Paul is correct, currently, we don’t have a method to include the hyperlink when referencing a value from another sheet utilizing a formula but this will be considered as a possibility for future development. Cheers, Eric Smartsheet Support
    inFind Corresponding Value (in Pieces) in Other Sheet Comment byeric.o 02/19/19
  • Hello, Yes, the community is a great place to test real-world examples and find the syntax for formulas you're looking to create based on your desired goal. The link provided above should be utilized for troubleshooting formulas we already have that are not working. 1. The AND Function formula provided above should only…
    inFormula help - VLOOKUP from another sheet with deduction based on other criteria Comment byeric.o 02/19/19
  • 你好,保罗是正确的,删除“”around the 1 may help resolve the issue. You also may want to confirm the column type the formula is within is a text column and the "Hedef Tamamlanma Tarihi" column is a Date column. Cheers, Eric Smartsheet Support
    informula about remaining days Comment byeric.o 02/17/19
Avatar