-
Help Desk - Communicating with end user
I'm using the Help Desk template to manage my incoming tickets. However, I don't see a way to be able to communicate with the end users within the system. I would like to be able to email the end user and have the email chain as an attachment to the row in the Smartsheet. Is this possible? It also doesn't seem to notify…
-
Zapier and Service M8 integration with Smarthseet
Hi, I was wondering if anyone has any info on how to achieve what i am trying to do: I have field management software that I use called Service M8 - it works with Zapier to update and or create rows in Smartsheet. We use Zapier to make a new row in Smartsheet and the trigger is when we make a new client in Service M8. That…
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Enable/Disable cells
Hello everyone Is there a way to make enable or disable a cells according to the values of another cell. A kind of conditional formatting with making enable or disable cells. Thank you in advance
-
Privacy Shield Application
Can I confirm progress, another thread says this self-certification expected to be completed by end of Q1-2017, I've had to hold off a wider rollout of some functionality to our business until this is resolved.
-
New suggestion for the reminder feature
Hi Thanks for the great feature that you have added to the notification roles I would like to Suggest adding the customization feature to the column that we want to present in the email message for the reminder alert when we edit the message. Best Khaled
-
How to hide #UNPARSEABLE error
Hey All, I have this formula =NETDAYS(Created16, [Due Date]16) and it's working just fine. It's just give me the number days left between two dates. But, when the data cells don't have values, it gives me this error "#UNPARSEABLE". I'm guessing I need to use an "IF" statment to eliminate this error, but I don't know how to…
-
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
-
"We received a bad request" on Outlook Add-in
I'm an IT admin trying to install the Smartsheet add-in for my users and am being faced with the "We received a bad request" error when trying to Connect with Office365 in Outlook. I have tried putting the ?prompt=admin_consent string the URL to give permissions, as well as add the add-in to the Exchange admin center. I DO…
-
Calculate duration excluding Weekends
Afternoon, I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts? =NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
