-
Row height issue
I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or changed the text positioning but the formatting didn't follow. I have un-hid and checked every cell for a spot that may have…
-
How to List Parents By Common Child
I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will automatically pull from this first sheet and show the resource and the projects that they…
-
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…
