-
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.
-
Check Box Column Property Not Working
I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It seems to remain as a Text/Number. Has anyone run into this? Thanks!
-
Unable to allocate task to user
Hi there, I have a task owner column (formatted as Contact). It seem very random on which users it will look up so I'm having to 'Allow' non-users a lot. I thought it might be change, where SmartSheet isn't allowing allocation to a non-licensed user however it sometimes won't pick up licensed users as well. All users have…
