If forumula

Karrie Davis

Karrie Davis Overachievers Alumni

03/26/19 edited 12/09/19 in Formulas and Functions

I trying to write a formula if (Days)<=30 will display an Amount in column 0-30

if formula.PNG

Tags:

0 ·

Comments

L_123 ✭✭✭✭✭✭

03/26/19

=if([Days t]1 <=30,Amount1,"")

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…