=Today()

G S
G S ✭✭
edited 12/09/19 in Formulas and Functions

Im putting this formula into a cell in a date/time property column and it returns the text "=Today()" ie with no functionality.

Tags:

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    If you have activated Dependencies for the sheet and trying to input it the formula in the Start or End date it will not work because you can't use formulas in those columns when dependencies are enabled but, you can type a "t" instead, and today's date will be added. 

    Hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Mike L.
    Mike L. ✭✭✭

    Are you trying to edit a sheet or a report?  Reports allow you to update data in the source sheet where the data originates but you can't enter a formula through a report. It would do exactly what you describe, display the formula as text with no functionality. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!