-
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)
-
Conditional Formatting on Linked Sheet
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as filled red, large bold text across the whole line. I want this to occur when the variance data is more than £9999. Currently…
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
