Hi,
I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form.
I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems to be working as intended. Is there a better way to design this formula?
=IF(Created@row = TODAY(), "Yes")
Then I added another formula to the green cells designated for Updated Today. This asks if all sites (or Name) had a "Yes" in the Updated Today column. This seems to be working as intended. Is there a better way to design this formula?
=IF(HAS([Updated Today?]1:[Updated Today?]8, "Yes"), "Yes")
I also need another formula to ask if a new entry was created the day before for all sites (or Name). Suggestions?
Thank you in advance.