Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange results. It would be nice if Smartsheet could…
I put a discussion out there, acknowledged by the increased badges that I received, but I find my inquiry missing for the past 24 hours. I have not received a message telling me that the information that I posted is inappropriate, so I'm confused. Thanks for what I may be missing.
We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be exported with line item details and there was no "key" to associate with a file export.…
When coding issues get beyond the incorporated realm of Smartsheet, such as in my recent post about time/date stamping, it is my understanding that Zapier, Smartsheet API, or compatible languages come into play. So, what are the opinions in the community about this. Do most folks incorporate a conglomerate of apps or stick…
I am trying to populate a "modified (Date) cell with today's date and time stamp (date only needed) only after populating a dropdown cell with data (non-blank). I've tried NOT(ISBLANK), but to no avail. The dropdown cell is used as a status cell indicating i.e., "complete", "needs follow-up", etc. The modified (Date) cell…