-
Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
Using appsheet with projects
My company has recently started using Smartsheet. We are a pool renovation company and each job is being set up as a separate project. We've been using appsheet for about 9 months now and want to incorporate our Smartsheet data. We want to have an app where our field workers are able to see each task assigned to them from…
-
Check boxes to search on a sheet
I’m trying to use check boxes to search on a sheet. Is it possible to show or hide rows based on a check box entry? Regards Steve
-
Is there any way to filter a schedule to only show activities occuring for a period?
If I have a schedule that is out to a year, but I want to filter for a schedule each week that only shows the previous week and the next 3 weeks, is there a way to do that? Start date and finish date filters don't work that well for that type of filtering. Truly, what I want is to show activities that have a bar going…
-
Webform Help
Hi Team! I use web forms to a large degree now for installation sign-offs for our field engineers, they are working great. Is it possible to build a conditional branch into a webform? So if I ask a question "Are you proud of the installation?" This is answered via a YES or NO dropdown option If "NO" is selected Can the…
-
Card View in Reports
Is it possible to have Card View in reports? It would be great to be able to see a card view board for multiple sheets at once.
-
use logic formula to copy an entire line to another sheet
Hi everyone!. I´m from Argentina and 1)thanks for helping :) 2)sorry for my english! :( I need to learn how to use a logical formula in SHEET A to copy an entire line to SHEET B, if one of the columns of the line to be copied has a "R" status ("R" from "restriction" that line has) When entire line appears in SHEET B, I…
-
Datamesh Contact Lists
Hi, We are trying to use datamash to bring over contacts to the target sheet based on locations in a source sheet which does not seem to be working. We have multiple contacts enabled and this works fine with vlookup, but datamesh returns no results. Any Ideas??
-
See projects rolled up in a program gantt
Apologies in advance if this has been answered before - and I imagine it must have been since it seems a very obvious and primary requirement for managing projects in a business. Still, for something this fundamental I just can't understand why I can't see anything in the solutions centre or a search here in the community.…