-
Seeing data in a report
Would someone need View permission to a worksheet in order to see the data presented in a report?
-
Building a CRM to track current and future business contacts
Good afternoon, I work at a community college and we don't currently have a CRM solution that will help me with the work I am doing. I am trying to create something to track current and future contacts on an organizational level as well as individual. One company might have only one contact but in the case of a larger…
-
Show Duplicates Based on Multiple Columns
Hi, I was looking for a solution to showing "Duplicate" if the combination of ColumnA @row and ColumnB@row of the same row appeared more than once. After taking bits of advice to similar problems in the community forum and reviewing the Smartsheet functions list, this formula solved my problem. I thought it would be worth…
-
Form did not populate a required field
I have a form and the first question is a required field. However, I have five entries (out of approximately 400) that have come into the sheet with no data for this required field. Has anyone seen this before? Any clue how this happened? Here's what I've checked: blank space is not an option (form won't let me submit)…
-
View Only account
Hi, I have paid my monthly fee and annual few but i still get a view only error
-
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
-
Help Text from Sheets on Reports
It would be amazing if the help text that is attached to sheet columns could be pulled into reports made from that sheet.
-
Lost all tasks in Gantt view
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…