-
What is the Default data type for "auto-numbers"
I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "auto number". In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of…
-
Issues with Smartsheet and firewall
Because our company have access control on network, so we need to setup rules on our fortigate firewall to make user can access smartsheet. I try to following old post to setup our firewall, link is on the below: https://community.smartsheet.com/discussion/3509/issues-with-smartsheet-and-firewalls FQDN *.smartsheet.com…
-
Can you make a sheet a sub-sheet of another sheet in card view?
I'd like to have a parent "card view" sheet, and multiple children sheets. The parent sheet would contain all of the cards in all of the children sheets and cards would be able to be edited on both the parent and the child sheet. This would be helpful for organizing cards by project, but allowing us to view cards from all…
-
How do I update my function syntax to stop getting the #INVALID DATA TYPE error?
I'm working within a sheet and trying to calculate the number of days between two dates. Above is a picture of what I'm seeing and my syntax is below. =NETWORKDAYS([Start Date]@row, [Date Completed]@row) I've tried to add IFERROR in a couple places and it didn't help with anything unfortunately. My Task Duration is set as…
-
Formula Help: Count number of time "Yes" occurs in a row?
Hi there! I am trying to write a formula that will count the number of times "Yes" appears across multiple columns in a single row. I am new to SmartSheet and having a hard time writing the formula. Can someone provide some guidance?
-
Use automated workflow to send an email to an external contact
Hi, I had a look through the existing questions, and couldnt find an answer to this, so apologies if it out there somewhere! we have a sheet where we log enquiries we receive as and when we receive them. In the log we capture the date the enquiry was answered, along with details of the enquiry and the response we provided.…
-
What causes a column ID to change?
Hello, What can cause a column ID to change? We have an integration from one of our software applications to a sheet, and we are having issues because the column ID will change without us knowing. Also, is there a way to see the column ID without having to use the API? For example, through a portal? We opened a ticket for…
-
Jira Connector: Where did the lightning bolt shortcut go?
There used to be a jira connector shortcut that looked like a lightning bolt on the vertical menu that seems to have disappeared for everyone at my company. Does anyone know how to get this back?
-
Duplicate data formula which references two values
Hello Community, I am trying to find duplicate invoice numbers for the same client within two of my sheets. I need to show if there have been any duplicate invoices for clients using two criteria but am unsure how to create the formula. I want this information to show in a checkbox form. =IF(COUNTIF([Invoice #]:[Invoice…
-
Adding a Smartsheet Form to MS Teams
Has anyone discovered a way to just add the actual form from a smartsheet to a tab in a Teams channel? I am looking for a way to have my dept. log and archive certain information that they come across in their day to day work. I felt the best way to do this was by giving them a simple form to copy paste that info into. I…
