-
Adding people to Groups
Does anyone know why I am getting this message "Cannot add this user to this group"? I created the group, however it is not letting me add everyone I need to.
-
Inconsistency in how contacts are displayed across sheets
Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name, its picking up the name from user name in my smartsheet account. But in other sheet…
-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Splitting form data from multi-select field into multiple columns on sheet
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way.…
-
Copy an Attachment between sheets
I am looking to copy an attachment only between 2 sheets. I can't seem to figure out how to do this! I have even looked at Zapier as an option, but not that familiar with it yet, so not sure how to make it work. Any suggestions?
-
Calculate total of each entry from multiple drop down selections.
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached. In my metrics sheet, I want to find out the total number for each entry. When I put 'countif' formula, it only considers…
-
How do I stop an approval workflow from going to everyone selected in the drop-down?
I want the request for approval go to the individual selected in the drop-down cell instead of everyone that is an option in the drop-down.
-
Can I use an INDEX formula to retrieve value from another INDEX Formula?
Hello, I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error. They are as follows: "IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retrieves the value I want. "=IF([Nov-19]110 = 0, 0, INDEX($[Jan-19]$189:$[FY50]$189, 1,…
-
Form Lookup
Is it possible to present a "Form" to a user, have them enter criteria. e.g. a unique customer number and then present other data to the user relating to that unique customer (e.g. the cust company name)? In other words, not provide them access to the sheet that contains the customer data.
-
Audit Compliance and Security Smartsheet
I'm looking for the smartsheet template that was shown in the Audit, Compliance & Security Solution Guide. The guide links to a site that no longer works - I was hoping to locate the template for the pre-audit checklist on page 5 and the project plan on page 6. Does anyone have a similar template to share? I'm starting…
