Hi, I found that the vlookup, Index and even a simple reference cells which work in Excel dont work

JohnnySun

How do I ensure the dates in the columns are autopopulated and the references in rows should be able to capture the successive dates in columns on formulae such as countif etc...

keith.mui

Hi Johnny you may find the nuances from Excel are written slightly differently in Smartsheets using the same formula with its unique column and row references. Particularly when referencing a report or another sheet you have made you can Tag the respective columns, rows, or cells with its own alias and edit them as you need.

Here is another article I referenced as a resource in learning the Smartsheets terminology specific to VLOOKUP

https://www.smartsheet.com/advanced-vlookup-multiple-criteria hopefully this can help in someway.

Keith

Genevieve P.

Hiya! Just chiming in here - the link above I believe is still referring to Excel for a few formulas. Our Help Center has Smartsheet-specific articles.

Here is a Help Article that specifically goes through cross-sheet formulas to help with the different types of lookups you may need to do:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

There are also some free webinars that you may find useful:

https://help.smartsheet.com/learning-track/best-practice-webinars/formula-foundations

Cheers,

Genevieve

JohnnySun

Thank you Amanda and Keith for your wonderful answers ! I will go through the links in detail and will get back to this section for any additional queries !