-
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…
-
Submit Bottom on Sheet
Hello, I'm trying to figure out a way to give indications to doctors to save the sheet before they exit. The intake sheet can't be a form, as I have images and over 100+ lines. I'm thinking of a visual cell with clickable formula may be. I'm open to suggestions. Thanks,
-
Only show calendar text (Primary Column) if other column = X
Hi, I’ve got this Primary Column for publication in our calendar: =([Event Title]@row + ", kl. " + Start@row + "-" + End@row + ", " + [Contact Name]@row) I’d like to only show this if dropdown column ”Booking” has the value ”Verified”. If dropdown column "Booking" is anything else, I'd like the Primary Column to be empty.…