cpo1✭✭

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…
  • Hi Andree, Yes, I did have one attachment. Maybe that's the issue. Thanks for the update.
    inPuzzled Comment bycpo1 07/06/19
  • 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…
Avatar