Help w/ Date formula

I am trying to make a formula that inserts the date when a selection is made in a drop down cell in another sheet. For instance, the user selects "IIMC / INSTRUMENT" in the training drop down. I want the date it was selected to fill into the other sheet.


Dropdown.

I want the date to go into this cell on a separate sheet.


Here is the formula I have, but I am getting an unparseable error:

=IF({TRAINING} = "IIMC / INSTRUMENT", {PILOT}PILOT@row, {DATE}, =TODAY())

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!