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…
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 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?
Due to limited screen space, I find the available Timeline Display options either far too dense to be useful, or too expansive. I propose: more Zoom settings. my issue is really that the zoom settings correspond to the heading incremements. my usability issue would be mostly resolved with more zoom level granularity. more…
Re-opening someone else's old enhancement request - We would love to be able to select from a wider variety of fonts, and especially have the ability to upload our own. Edit: This was meant to go into enhancement requests but I think I added it to the normal forums, I apologize! 😓
