- Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?
- conditional formatting question
Hi, I have a conditional format setup to look at a specific product line and GEO when it does not contain specific geo's then apply a grey format to 2 fields, so that people know that nothing is required in those fields. The specific product line was not met and the GEO did include the 1 of the specific geo's. Isn't the…
- Best practice for sending notificatons from 1 smartsheet based on users in a 2nd smartsheet
Hi, I have a master smartsheet with client name, a date and the clients product lines, on a row. The product line column is a multiple select, restricted to a specific list of values. I have second smartsheet by department and users within the department. I am thinking of adding the product lines which the department is…
- column description on sheet does not show on report
Hi, I have two sheets with column descriptions. I have shared these sheets via a report for users to make their updates. From the Report they do not see the column descriptions. Is there a way they can see the column descriptions? Thanks, Peggy
- how to export list of users from sheet sharing?
Is there a way to export the list of collaborators from the sheet sharing view of a Smartsheet?
- 从1创建表内容报告for updating, need to allow users to set their own filters
Hi, I have a Master Smartsheet, that I created 20 reports from. Each report is a filter for each user and shows just the columns that need to be updated. As we add add more data by phase in the master sheet, each user wants to filter the data by phase as they are working through their tasks. Edit permission does not allow…
- Joining 2 sheets into a report is not pulling data from second sheet
Hi, I have 2 sheets, they are both in the same workspace Each sheet has a different primary column. Can this be the reason why the new report to pull from the two sheets, is not pulling the data? Thanks, Peggy
- Invalid data type error
Hi, My formula is =COUNTIF({Range 1}, AND(MONTH(@cell) = 3)) and i am trying to count the number of dates in march. my date column (Range 1) is 03/01/22 I am getting a invalid data type error. thanks for your help. Peggy
- Getting an unparseable error for my formula =IF,VLOOKUP
Hi, I am getting an error and i tried INDEX and MATCH as well. Here is my stmt I want to pull a unique number in a column when the row has a grouping of "Remote Access + No shared Folder" =IF({Client Grouping}@row = "Remote Access + No shared Folder", VLOOKUP({Active Clients - Master Range 1}@row, 1)) not sure what else i…
- Formula question when counting 2 values in a restricted drop down values only column
Hi, hope you can help me. I have this formula =COUNTIFS({Clients Status Active}, "Active", {Client Grouping}, "Remote Access + Shared Folder – Not Validated") and i want to add 1 more criteria {Primary ID}, "Y", "Generic") I want it to count both the "Y and Generic" in the primary ID column. I keep getting a incorrect…
