-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the review…
-
Integration with Converse.ai
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,
-
Need report to prompt for string search
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 string for report to show rows whose address column has such string. Something like {{Enter search string}}...
-
Looking to count the number of Stars
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?
-
Power BI
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 that means or if I have opportunities I should be investigating.
-
How do i create a calendar within forms that will block off certain dates?
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 able to have about 10 people sign up for, so that date will need to be crossed out once that limit is reached.
-
Smartsheet Security Best Practices Guide
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. Reliable security, compliance, and governance features have become the key capabilities needed for the wide-scale adoption of…
-
Apostrophe added on mass insert thru CDATA
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 checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
Formula for Actual duration excluding duplication
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 days only, but including not contiguous time ranges. Please see example: Start: 01/10/2019 End: 04/10/2019 = 4 working days…
-
Jira Connector only allowing one project to one sheet
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 collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
