Hi, I am building a bot on Converse.ai. How can I integrate smartsheet into my bot? I specifically want my customers to be filling out forms at a certain stage of the bot Thanks,
Hi, I am creating a sheet tracking City's address modifications. There should be a report where users can see if there already were rows with similar address. Hope there is a way to enter a search str…
Hello all, I'm looking to count the number of "stars" within a column and have been testing with =COUNTIF(check_column, "true"). This isn't working. Any ideas?
Has anyone used Power BI with Smartsheet? I do a lot of things in Smartsheet, and we have another department doing things in Power BI. I see articles in Smartsheet about Power BI, but not sure what th…
I have created a form that I am using to send to people to sign up for something. I need them to be able to select a date, but have some that aren't available to be crossed out. Some dates will be abl…
As the adoption of cloud-based systems increases across organizations, the security of information and data contained in such systems becomes increasingly important for enterprise IT and leadership. R…
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checki…
Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort da…
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is co…
Is there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so…