In the Valueiftrue field, type the value you would like entered in your cell if B2 equals Y. Add the equals sign and your desired value in quotes. For example, to get top 3 scores in a given. Excel will fill in the cell reference such as B2. To find the largest values based on condition, use this generic formula: SORT (FILTER ( values, ( values >LARGE (IF ( criteriarange criteria, values ), n )) ( criteriarange criteria )), 1, -1) Where n is the number of top entries to extract. Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.įind examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community. Click the spreadsheet cell you wish to evaluate. If neither applies return the value “Green”. IF the “Order Date” column row 2 is greater than or equal to TODAY, AND less than the next 7 days, return a “Yellow” value. IF the “Order Date” column row 3 is less than TODAY return a “Red” value. IF the “Order Date” column row 2 equals TODAY return a “Green” value. IF the “Order Date” column row 2 is greater than TODAY return a “Yellow” value. IF the “Order Date” column row 2 is less than TODAY return a “Red” value. IF the ‘Status’ column row 1 equals “Red”, return the value "At-Risk”, if not return the value “On-Time”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |