-
Report Issue
I have created a report that pulls info from 5 different sheets, and have set the report to group by the project column. All projects are being grouped correctly, except 1. The Coding Rewrite project is displaying each row individually. Interestingly, when I change the group setting to group by Sheet name, it displays…
-
Summary Report
We have created a grouping in a report. As per requirement, we grouped by date, but we need to remove/hide the highlighted information from the sheet. We have tried in the way Grouping by the column type "Month, Year" , but through that it is grouped by month name alphabetically so not fulfil my requirements.
-
User tried to add sheet owner as a Contact in a multi-select contact field, removes other contacts
I created a form/sheet that has the entire team as dropdowns in a contact field. When a user tries to add my name, it removes all other contacts from the multi-select field. Why is this and is there a fix?
-
Receive an emailed attachment on submission of form.
Im creating a shipping request sheet and have created a form so people can submit address details etc . Once submitted this will go to a department for approval. I would also like an attachment to be sent with the email . For example, the email goes to the shipping department for approval and a standard packing list is…
-
How can I make a pie chart that aggregates dropdown choices in a column?
I have survey results that I need to make into a chart - for example, let's say for a question where they rate something from 1-5. Ideally, in a pie chart, it would show that x% of respondents answered 4, x% of respondents answered 5, etc. But instead, each row is getting its own pie slice. How can I make it so that it's…
-
Reminder: Request to join Smartsheet Account
Hi, I am the system admin of smartsheet in my organisation, using business plan account. I have invited some of my colleague as free collaborators to view the sheet. The free users know they only need to view and never request for license. However I have received the following reminder email from smartsheet for a number of…
-
How do I create an assignments summary sheet?
I'm working with a healthcare department, and our staff are assigned cases to contact trace. They contact the individual or facility, enter in the relevant info to a master sheet, take whatever notes they need, and then mark it as completed. The problem I'm having is creating an assignments summary sheet. Each investigator…
-
Issues with TODAY formula
I'm using this formula (=COUNTIFS({FINAL - Post Check Tracker Range 24}, "Outstanding", {Post Check) to count entries completed today from another sheet. The formula is pulling information from the automated "Created" column in the other sheet and it appears to be counting more than just todays entries. Any assistance with…
-
Can the selections from a dropdown multi-select question in a form be used to auto create columns?
If I have a question in a project intake form that allows for individuals to multi-select all of the rooms that will be a part of a project can I then in turn use those selections to automatically create columns in the worksheet that corresponds to the rooms that were selected? Thank you for taking the time and any…
-
Attach a document to a Form
Hello, Can you attach a document to a Form? Thanks!
