Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.
Hello all -- I want a sheet which will be used for contractors to log their planned billable hours, their actual hours, and their planned time away for a given week. The spreadsheet will have multiple weeks in it, and contractors will fill it out for several weeks at a time (the planned hours and planned time away). As…
I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest…
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
We would like to track the usage of Dashboards, Forms and sheets if it is possible similar to Google Analytics?
Example: We used dynamic view to create a web content widget in Dashboard. We are able to use Filter option to bring out status of rows but it would be very helpful if "Search" option is present. Our expectation-- By entering a keyword in the dashboard widget it has to pull the rows of smartsheet table having the…
I would like to be able to set up recurring backups for reports and dashboards just like we are able to do so for Sheets in a workspace.
I feel like I'm clicking endlessly... 👆️👆️🖱️Double-click to open the cell formula 👆️👆️🖱️Double-click to highlight the part that I need to edit 👆️👆️🖱️Double-click to open and edit the next cell... My hand hurts. It would be great to have some sort of edit pane that allows me to edit all formulas on a sheet at once. Or…
The web content widget doesn't shop up on mobile. It shows a generic icon, will this ever be fixed?