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…
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details Any suggestions to the best app…
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a re…
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information f…
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. This is the formula I started using based on responses in the community: =INDEX({TES…
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming i…
Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the P…
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are …
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet tha…