Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g.…
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown …
Table 1 is a list of products that contains among others columns Trade Name, Country, Crop and Last Modified (Auto). Within the rows, one trade name can refer to different countries or crops. In Table…
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula…
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are …
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inabili…
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to…
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matc…
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying …
Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning even…
