Is there a way to get todays date?


Hello I don't think this is possible but i was just wondering if there is a formula or way that i could use to pull today's date and have it auto populate the cell once the form is submitted. Currently I have it set up so in the form they fill out they just enter today date but i didn't know if there would be a way to streamline it to where the date would automatically be there and they wouldn't have to fill it out on the form as the form has 30 other questions on it. I would even be okay if i had to have a second smart sheet with every date listed and have it pull from that one. The only problem I see with that is how would the sheet know which date to pull. Let me know if what I am thinking of doing is even possible or if I'm just crazy.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!