Formulas and Functions

Archives for December 2015

If a date is within 7 days of todays date
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 it working on smartsheet. Thank you

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Cell Linking
Can you do cell linking within the same sheet?
Froms Font
Can I change the size of the font in a form? The description font is very small. And how do I change the color / size of the link…it's there in blue but I want to make it white. I tried using the edit option to the right but it's not changing.
Using MATCH() to identify row # on checkbox column
I have a checkbox column I'm using to identify a specific row in a sheet based on criteria. I'm trying to use the Match() formula in the sheet summary to identify the row number in the checkbox column is checked but its coming back #NO MATCH. Feels like this formula should be easy but I can't seem to get it… My formula:…