Formulas and Functions
Archives for December 2015
Discussion List
- Hi I am trying to create a formula to hight light a cell if the date it contains is within 7 days (prior) to todays date... Can anyone help, I have this working on a spreadsheet but cannot seem to getβ¦
Help Article Resources
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a sβ¦
- I currently have this formula working to return the Store number that is Type - TRH. =INDEX(COLLECT({Copy of Construction-Checklist STORE NUMBER}, {Copy of Construction- TYPE 3}, "TRH"), Number@row) Hβ¦
- I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary sectiβ¦