-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Using INDEX MATCH Function with a Multi-Select drop-down column
Hello, I am trying to use an INDEX MATCH function to fill in the Transmission Region for the Sites Under Consideration, but am running into a problem when there is more than one site selected. I believe I need to add the HAS function, but have tried several ways and can't seem to make it work. Any help is appreciated!
-
How do I get a hold of customer service?
I opened a case 10 days ago and have not been contacted nor has my issue been resolved.
-
How Do I Contact the Smartsheet Support Team?
Hi Team We are using Smartsheet in our Organisation and urgently need assistance with some formulas which are giving us issues. I am not sure who to contact please, can someone assist me? Thanks so much Benie
-
How long does it take for a support ticket to be addressed?
I submitted a ticket yesterday afternoon in the portal and it still hasn't been addressed/actioned. What are typical ticket response times?
-
Help with a dynamic status column
Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamically update based on the check boxes in the columns. If all the checkboxes@row = 0 then status would be "not started" but if…
-
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…