Comments
-
Thanks Alejandra. I appreciate your feedback. I'll be looking into that function soon. Have a great day.
-
Here is an example of what I was doing, except that I wanted the date to be a static fixed date, so I used "07/06/19" in lieu of TODAY(). This formula worked and populated the cell with 07/06/19 and I assumed that the date was a date, not a text date since the quotation marks were not present. I came to realize that the…
-
Thanks for the help Paul. I appreciate it. I had gotten to the part where the year didn't like a change, so your explanation is a great help. I'll work through it soon. I had found and opened "Smartsheet Forumula Examples" which are a big help and I used the year,month,day (date function). It worked fine until a change of…