-
Cross-sheet reference limited to under 50,000 references
Excited about the increased cross-sheet reference limit to 100,000, I jumped on the bandwagon and started to replaced the Destination sheet LEFT(SUBSTITUTE(JOIN formulas with the Index/Match formulas using cross-sheet references. In this workflow, we are pulling data from 5 Source sheets into one βCentral (destination)β¦
-
Formula to check a box if it meets multiple criteria in another sheet
Hi! I have two sheets: Sheet A: ID#, Date, and a checkbox Sheet B: ID#, Date Can someone please tell me what should the formula be if I want to Sheet A checkbox to check if Sheet A's ID# and Date match with Sheet B's ID# and Date. I tried a few different formula and it seems like it doesn't work: =IF(AND(MATCH([ID #]@row,β¦
-
Need Formula Help
Hi There! In need of a formula to that would sum time based on these columns: Resource Name Group Name Week Ending This is my time repository, I need to sum each resource's time based on Group Name and Week Ending (which is actually the Date Column, my Week Ending column has to be a text column) on another Sheet. Anyβ¦
-
Vlookup with Another Sheet
I have a sheet where I have two columns I would like to automatically populate based on the "job Code" column I have entered. In Excel, I used vlookup for the list of Job Codes to reference. I have uploaded those to a new sheet- how can I set up my vlookup to return the values I need? I keep getting and Unparseable error.β¦
-
Hide Error
Hi, I have a sheet with a couple of big weighty formulas. Sometimes the cells containing the formulas are not required to be used in the row and criteria might be missing in the row and so the error #INVALID VALUE appears as expected. How can I hide this error from the sheet as it shows up on reports and makes them lookβ¦
-
Conditional Formatting
I am working with a ton of different sheets, about tasks that are being complete or not. I am trying to have conditional formatting where it would be easier to see the tasks that are needing attention compared to those that are complete. I have found this to be very tedious because I am having to go through each column andβ¦
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.β¦
-
Connect sheets without manual cell linking
I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate sheet to be able to live update when changes are made. I don't think an automatedβ¦
-
If Blank return no value
How would I eliminate the #INVALID VALUE entry when the Start Time is BLANK? Thanks for your help! Here is the formula below. It converts time to Military time. =VALUE((VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) - IF(VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) = 12, 12, 0) +β¦
-
Filling in a Form field to show a list from a sheet
Hello. Smartsheet GRID file contains a Client Master List.Β Client Master List has Client Number and Client Name columns.Β My Travel RSS Schedule Request Form for assigning Techs to Clients for travel, asks for the Client Name to be entered into the Form. So, what Iβm wondering is, can Smartsheet query / lookup on a Formβ¦