-
How can you edit a collborators e-mail address?
I want to edit an e-mail associated with a collaborator because it has changed. There seems to be no way to edit anything in the Sharing area. I know how to edit My Smartsheet Contacts, but that doesn't help. Sometimes the collaborator contact doesn't show up in My Smartsheet Contacts. Even if it does, and I successfully…
-
Notification
Hi all, I need some help... Whilst I am of the understanding that you can set up notifications when a user makes any changes to a sheet, is there any way you can be notified if someone has in fact opened a sheet they have been invited to view? Thanks in advance
-
If value used elsewhere then conditional formatting
On one of my sheets we have a column with order reference numbers with the following format XYZ0123. I have been trying to set up a conditional format to warn me if I am reusing a previous number further down in the same column. So, if I enter ABC0345 and it has already been used in one of the cells further down the same…
-
automation of checkbox or RYG balls (or something)
Good morning! I have 3 sheets that work together to serve various functions, including taking daily attendance. MASTER CAST LIST lists each person's name, SIGN IN SHEET and CONFLICT CALENDAR are driven by forms with contact formatted drop down lists. It's all the same people on each of the 3 sheets and the primary columns…
-
Can a Workspace be Deleted?
Hi, I am new to Smartsheet. Is it possible to delete a Workspace? If deleting a Workspace is possible, can I please get the steps to do this? If it is not possible to delete a Workspace, what practice(s) are users implementing for Workspaces that are no longer in use and that we no longer want to see? Thanks
-
notification
can i set a notification that is driven by a date and a name. ie i have a date column with a date range for my local school term, showing weekdays only. my next column is a recurring set of names, and finally my third column is a column titled 'tasks'. what i want SS to do is to send the person in column 2 a notification…
-
Client list in card view
Hi guys, we've been using smartsheet for about a month now. We have our client list set up in card view which is taken from my smartsheet contacts. If you hover the mouse over the contact it only shows their name and email address. Is there anyway this can come up with their phone number too? We have phone numbers set up…
-
Data privacy in community app
I'm new to the fantastic community and have a question re data privacy. When registering with my Smartheet details I was required to allow the Smartsheet Community App to "Read Sheets, including attachments and comments". I presume that this simply means that the app is allowed to verify my account, rather than that my…
-
Selective Count
I’m trying to get a count based on 3 different conditions. The formula that I have so is =countifs($[it track]$2:$status$500, “01. Reporting”, $[it track]$2:$status$500, “ Tier 1”, $[it track]$2:$status$500, “Green”) If all 3 conditions are met than a count is added. But its not working what am i missing? Thanks
-
switching accounts
I have been with my company for 9 months now, and prior to my employment that have not heard of smartsheet. I purchased Smartsheet before I was employed here and intrduced it to the company. Since then the company has seen how useful it is and wants to purchase and pay for it. How can I get the account switched over to the…
