pallet configurations in smartsheet

sshweky

sshweky ✭

01/12/18 edited 12/09/19 in Formulas and Functions

Does anyone have a way to figure out pallet configurations in smartsheet given the case specs?

Tags:

0 ·

Comments

Shaine Greenwood Employee

01/15/18

Hello,

Can you elaborate more on what you're wanting to accomplish?

Happy to advise with more information.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Fiscal Year "lookup" formula request
Hi :) I'm trying to get this lookup to pull in the FY for us but these always give me a hard time. I have the excel formula but I don't really even understand it so not sure how to translate it to Smartsheet talk. Excel: =LOOKUP(2,1/((H268>='Lookup Data'!$B$2:$B$21)*(H268<='Lookup Data'!$C$2:$C$21)),'Lookup…