-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
Date Validation
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. Ultimately I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.
-
Integrating with SharePoint
I would like some suggestions for integration with SharePoint. What are the best practices and ways to share information. Will information shared be actively updated or is it best to generate reports to be shared as static images that update at certain intervals? All suggestions would be much appreciated.
-
ERP System
Can someone please advise if Smartsheet links with an ERP system? Is there one software that is more recommended with others? I did see that there are some integrations with ERP ( Acumatica, Meisterplan, etc). Are there others that I may be missing? Please advise thank you!
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
IOS App Calendar feature
Hello, Does anyone know if there is a way to set the default width of the 'days of the week' on the IOS calendar app? It would be huge if I could expand them. I can expand them when I open the app manually, but it would be great if I could have them open expanded. Thanks in advance, Dan
-
Integration with Infusionsoft
I see there is an integration for Salesforce, but is there currently or plans in the future to build an integration with Infusionsoft? Infusionsoft is a tool that all small businesses are or should be using to automate their sales and marketing. It would make sense that smartsheet would integrate with Infusionsoft.
-
Smartsheet Merge Permissions Issue
I'm on the trial version, but will definitely upgrade to paid versions for our company. One of the most important features for us is the Google Docs Merge functionality, but I'm having trouble installing Smartsheet merge. After add-on install, I hit "Connect to Smartsheet" and it takes me through various permissions dialog…
