-
RYG Ball Automation
Hi there, I am trying to automate the 'Health' column on a sheet. I have it set up to turn RYG when a certain status is selected but I would also like it to turn Red if the Due Date or Due for Review is a past date and the status is still listed as anything but 'Complete." I currently have this formula in place…
-
Need help getting multiple sheets pulled into a single report in the correct order
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last. I did a bulky workaround by adding a Helper Column in each sheet…
-
Receipt for Work Completed
I want to auto generate a receipt with Zapier or something and send it to the supervisor and client upon work completed. Problem: Our electricians perform tests on all equipment we install. We have many QC forms that we use but using them is very cumbersome. Our techs need to ensure that they print them off before going to…
-
Clear RYGB balls on completion of a task
Hello, Currently we are using the RYGB balls as a priority indicator. One of the things that happens when you are completed with the task is that you have to clear the ball manually. I would like to automate the task. <Column 1> RYGB <Column 2> is a drop down with the following "Canceled", "Pending" and "Released". I would…
-
Delivery Set Up
Hey everyone, I have a question. My set up: Multiple line items with different Work Package Names. Once the work package is complete we mark it for shipping based on date and time to our job sites. I would like to have a sheet that would consolidate all the work packages (name of the work package) to one row based on that…
-
Editing a Drop Down List
I am creating a Tasks List and am wanting to use a Drop Down list to indicate the Client the Task refers to. Our Client list is ever-changing. Am I able to add or delete clients from the Drop Down list without affecting the data in the other Client cells? I am hoping to keep the list alphabetical, so additions and…
-
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
-
Direct entry of images in to row cell of a Project Tracker sheet using FORMS
hi I am trying to develop Project Progress tracker wherein I intend to get my construction site photos in to my progress sheet using information update by way of a FORM. My current challenge is that I can get photos uploaded through form but they get located in comments tabs and for every time I have to first manually…
-
ODBC Connections and Outside Apps
Hi all, Hoping i can find some recommendations that can assist with an app development. I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end. I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has…
-
Card View in Android App?
I would like to use the card view in the android app, is that possible?
