-
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.…
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…