-
How to flag AT Risk task
I have Planned FInish Date (Date field), and Actual Finish (Date field) and % Complete field, I want to flag the task if it's past due and incomplete. currently I tried :=IF(OR([Plan Finish]@row - DATEONLY([Actual Finish]@row) < 0, [% Complete]@row < 0), 1) but not working as intended. Thanks DJ
-
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…
-
max value by category
Hi I'm stuck on figuring this one out. I am trying to generate a sequential number("Sequence" column) by category ("Application"). I want the formula to calculate the max value of all the records in sequence where application = application in the new record (user would have selected this from a drop-down. this is what I am…
-
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…
-
Need a drop down list to populate it's selection based on the selection from another drop down in th
I am creating a survey sheet and forms. I have created two drop down lists in my sheet (easy enough). One holds 5 selections for neighborhoods in NYC. The second column conains addresses all over the city, all found in one of the 5 neighborhoods. I would like to be able to select a neighborhood from column 1 and then have…
-
Dashboard Widget
Hi, Is it possible to create a dashboard widget that contains an <iframe> with contents from another external site? // Leif
-
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…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
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…
-
Alterar o modo de visualização da planilha individualmente
Olá, foi o possível substituto do modo de exibição da planilha doce? a Planilha é compartilhada, mas todo usuário tem sua função e visualiza o conteúdo de forma, porém, cada mudança, por exemplo, no tamanho da barra, altera para todos os usuários, sendo que essa alteração é tão séria necessário para um único usuário.
