- % Complete staying 0
Good Afternoon, I am new to Smartsheet, and am having trouble with what seems to be a simple task. The parent % complete will not change from 0%, no matter what I put in the child's information. Thanks.
- Filter tables based on dropdown menu selection
Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustrate what I'm looking for. Here's what the raw tables look like. They are laid out like…
- 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
嗨,我是创建一个年代heet 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.
