Using =Today() to replace in place of a cell reference formula

https://community.smartsheet.com/discussion/comment/421684#Comment_421684

In regards to above linked question/answer from KPH 2/24/24 - 3rd to last Parr. mentions using today's date rather than a referenced cell. Can someone elaborate - If there is no cell reference where do is the today formula inserted into the overall formula. ie: if using Base Date cell reference is:

= DATE(YEAR([Base Date]@row), MONTH([Base Date]@row) + 1, 1) - 1)

change to current today's date? - where is the =Today inserted. below yields incorrect argument

= DATE(YEAR(=Today(), MONTH(=Today() + 1, 1) - 1)

Find more posts tagged with

Accepted answers

kmorsesmartsheet

I appear to be missing something - now I have:

= DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1)

Unparseable

Paul Newcome

The closing parenthesis at the very end also needs removed.

All comments

Paul Newcome

Just remove the = from before the TODAY() functions and make sure you have the appropriate parenthesis.

YEAR(=Today()

changes to

YEAR(TODAY())

MONTH(=Today()

changes to

MONT(TODAY())

kmorsesmartsheet

I appear to be missing something - now I have:

= DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1)

Unparseable

Paul Newcome

The closing parenthesis at the very end also needs removed.

kmorsesmartsheet

PERFECT - Thank you Paul!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.