-
Form Automation
Hi, My vision is, that when a form is submitted, it is placed into the appropriate bucket based on the person assigned. For example, a new task is submitted for Austin via a form, when submitted, it is placed in row 1. I would like it to move into Austin's task area automatically. Is this possible?
-
Problems with using formula to count items in drop down list
Hi I am hoping you can help me out here. I am trying to create a pie chart on a dashboard to display the proportion of technology types that are being serviced. This is a drop-down list with 5 different values. I read it is easiest to count the values individually in the Sheet Summary and then use that to create the chart…
-
Formula to make it to check the checkbox in another sheet.
Hi all Hope you can help me. i'm trying to make a formular that can help me check off the checkbox in another sheet. So its going to be somekind of formular that looks into another cell and if it is checked off it is going to checkoff in that sheet as well. So 1. sheet is the Intake sheet. - The 2. sheet is the tasklist.…
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
Auto Number Column is Being Copied Over From New Rows
I have a row ID setup with auto numbering on a totals sheets that contains all the copied rows from multiple projects. When the copied rows are inputted into the total sheets (using automation) the row ID is then updated with the row ID from the other sheets. I use this auto number field to identify duplicate rows (and in…
-
INDEX(COLLECT( )) where some rows are blank
Hello Community! I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet. The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with…
-
FORMULA HELP? max/collect/if
I am trying to get information from another sheetA to sheetB I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏 Please bear in mind new rows…
-
Nested IF & VLOOKUP for Checkbox
So I'm trying to write a formula to pull a date from Sheet 1 if a checkbox is checked and match it to the same email on Sheet 2 . =IF({Sheet 1 Range 1} = true, VLOOKUP([Column2]@row, {Sheet 1 Range 2}, 3, false), "") Occasionally Smartsheets gives me trouble with pulling information from date columns that I've set to pull…
-
Formula to Find the Start/End Timeline
Hello SS Community, I'm trying to find a formula to insert in the sheet summary that brings the earliest Quarter and Fiscal Year (FY) and the last/furthest quarter and FY. Thank you in advance.
-
Complicated IF Formula
Hi, I am looking to do a formula that will let me display the red, yellow, or green symbols depending on the amount of answers are green, yellow, or red. The picture might let me explain better. The left column is Status and the right column is Constant. Only the top 3 Totals will count towards the result. Total NYIOP…
